By Robert Stackowiak, Jonathan Stern
Written by means of Oracle insiders, this essential advisor distills a major quantity of knowledge concerning the Oracle Database into one compact quantity. perfect for beginner and skilled DBAs, builders, managers, and clients, Oracle Essentials walks you thru applied sciences and contours in Oracle’s product line, together with its structure, facts buildings, networking, concurrency, and tuning.
Complete with illustrations and invaluable tricks, this 5th version offers a worthy one-stop evaluate of Oracle Database 12c, together with an creation to Oracle and cloud computing. Oracle Essentials presents the conceptual history you want to know the way Oracle actually works.
- A entire evaluation of Oracle databases and information shops, and Fusion Middleware items and features
- Core suggestions and buildings in Oracle’s structure, together with pluggable databases
- Oracle items and many of the datatypes Oracle supports
- System and database administration, together with Oracle firm supervisor 12c
- Security recommendations, easy auditing features, and ideas for assembly compliance needs
- Performance features of disk, reminiscence, and CPU tuning
- Basic rules of multiuser concurrency
- Oracle’s on-line transaction processing (OLTP)
- Data warehouses, colossal info, and Oracle’s enterprise intelligence tools
- Backup and restoration, and excessive availability and failover solutions
Read or Download Oracle Essentials: Oracle Database 12c PDF
Best Computers books
Electronic layout and computing device structure takes a different and smooth method of electronic layout. starting with electronic common sense gates and progressing to the layout of combinational and sequential circuits, Harris and Harris use those primary development blocks because the foundation for what follows: the layout of a precise MIPS processor.
Grasp the Linux instruments that would Make You a extra effective, powerful Programmer The Linux Programmer's Toolbox is helping you faucet into the substantial selection of open resource instruments on hand for GNU/Linux. writer John Fusco systematically describes the main worthwhile instruments on hand on such a lot GNU/Linux distributions utilizing concise examples for you to simply alter to fulfill your wishes.
Robert Sedgewick has completely rewritten and considerably increased and up-to-date his well known paintings to supply present and entire insurance of significant algorithms and knowledge constructions. Christopher Van Wyk and Sedgewick have built new C++ implementations that either exhibit the tools in a concise and direct demeanour, and in addition offer programmers with the sensible potential to check them on genuine functions.
The objective of desktop studying is to application pcs to take advantage of instance facts or previous event to unravel a given challenge. Many profitable functions of laptop studying already exist, together with structures that study previous revenues information to foretell client habit, optimize robotic habit in order that a job will be accomplished utilizing minimal assets, and extract wisdom from bioinformatics information.
Extra info for Oracle Essentials: Oracle Database 12c
243 information Warehousing fundamentals The Evolution of knowledge Warehousing and enterprise Intelligence A Topology for company Intelligence info Marts The Operational info shop and firm Warehouse viii | desk of Contents 244 245 246 247 248 OLTP structures and enterprise Intelligence vast info and the knowledge Warehouse info Warehouse layout question Optimization Bitmap Indexes and Parallelism Optimization supplied by means of the Exadata garage Server software program Dimensional info and Hierarchies within the Database precis Tables Materialized perspectives OLAP choice Analytics and records within the Database easy Analytic and Statistical capabilities different SQL Extensions complicated Analytics alternative different Datatypes and large information Loading info into the information Warehouse handling the knowledge Warehouse enterprise Intelligence instruments Oracle company Intelligence origin Suite enterprise Intelligence purposes facts Discovery and Oracle Endeca info Discovery Oracle Exalytics The Metadata problem placing all of it jointly a whole Analytics Infrastructure top Practices universal Misconceptions potent method 249 249 250 252 253 255 256 256 257 257 258 258 259 260 262 263 265 267 267 269 270 271 271 272 272 273 274 275 eleven. Oracle and excessive Availability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 277 what's excessive Availability? Measuring excessive Availability The procedure Stack and Availability Server undefined, garage, and Database example Failure what's example restoration? stages of example restoration conserving opposed to procedure Failure part Redundancy Disk Redundancy automated garage administration website and computing device Server Failover Oracle info shield and location mess ups 278 278 280 281 282 283 284 284 285 287 288 289 desk of Contents | ix Oracle lively facts protect and 0 facts Loss Oracle GoldenGate and Replication genuine software Clusters and example disasters Oracle obvious program Failover Oracle software Continuity improving from mess ups and knowledge Corruption constructing a Backup-and-Recovery process Taking Oracle Backups utilizing Backups to get better restoration supervisor Read-Only Tablespaces and Backups out of date info Redundancy Point-in-Time restoration Flashback deliberate Downtime 291 291 293 296 298 299 299 three hundred three hundred 302 304 304 305 305 307 12. Oracle and structure. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 309 approach fundamentals Symmetric Multiprocessing structures and Nodes Clustered ideas, Grid Computing, and the Cloud Disk and garage know-how Oracle’s Engineered platforms Oracle Exadata Database computing device Oracle Exalogic Oracle SuperCluster Oracle Database equipment different Engineered platforms deciding upon and Defining the best Platform Sizing and making plans for development greatest Availability structure concerns Justifying an Oracle Engineered method 310 311 313 316 317 317 320 321 322 322 323 323 324 325 thirteen. Oracle allotted Databases and dispensed information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 327 having access to disbursed Databases disbursed info throughout a number of Oracle Databases entry to and from Non-Oracle Databases Two-Phase devote Oracle Tuxedo Replication and information delivery Replication fundamentals historical past of Oracle Replication choices Oracle GoldenGate x | desk of Contents 328 328 329 330 331 333 333 334 335 Global facts providers facts shipping utilizing Database good points 336 337 14.