Posted by 
By David Fitzjarrell, Mary Mikell Spence
Oracle Exadata Survival advisor is a hands-on consultant for busy Oracle database directors who're migrating their ability units to Oracle's Exadata database equipment. The e-book covers the techniques at the back of Exadata, and the to be had configurations for good points reminiscent of shrewdpermanent scans, garage indexes, clever Flash Cache, hybrid columnar compression, and extra. You'll find out about functionality metrics and execution plans, and the way to optimize SQL operating in Oracle's robust, new surroundings. The authors additionally disguise migration from different servers.
Oracle Exadata is speedy changing into the traditional for giant installations resembling these working information warehouse, company intelligence, and large-scale OLTP structures. Exadata is like no different platform, and is new flooring even for knowledgeable Oracle database directors. The Oracle Exadata Survival consultant is helping you navigate the fine details of this new platform, de-mystifying this remarkable equipment and its extraordinary functionality. The booklet takes a hugely sensible strategy, no longer diving too deeply into the main points, yet supplying you with simply the suitable intensity of data to fast move your talents to Oracle's very important new platform.
Helps move your abilities to the platform of the future
Covers the real floor with no going too deep
Takes a realistic and hands-on method of daily tasks
What you’ll learn
Learn the elements and simple structure of an Exadata machine
Reduce information move overhead by means of processing queries within the garage layer
Examine and take motion on Exadata-specific functionality metrics
Deploy Hybrid Columnar Compression to lessen garage and I/O needs
Create worry-free migrations from latest databases into Exadata
Understand and tackle concerns particular to ERP migrations
Who this e-book is for
Oracle Exadata Survival consultant is for the busy company Oracle DBA who has by surprise been thrust into the Exadata area. Readers must have a valid snatch of conventional Oracle database management, and be ready to benefit new facets which are particular to the Exadata equipment.
Read Online or Download Oracle Exadata Survival Guide PDF
Similar computer science books
Designed to offer a breadth first insurance of the sphere of machine technology.
Each one version of creation to info Compression has extensively been thought of the easiest creation and reference textual content at the artwork and technology of knowledge compression, and the fourth version maintains during this culture. information compression innovations and know-how are ever-evolving with new functions in snapshot, speech, textual content, audio, and video.
Desktops as parts: ideas of Embedded Computing approach layout, 3e, offers crucial wisdom on embedded structures know-how and strategies. up to date for today's embedded structures layout tools, this version positive factors new examples together with electronic sign processing, multimedia, and cyber-physical structures.
Computation and Storage in the Cloud: Understanding the Trade-Offs
Computation and garage within the Cloud is the 1st finished and systematic paintings investigating the difficulty of computation and garage trade-off within the cloud as a way to decrease the final software rate. medical functions are typically computation and knowledge extensive, the place complicated computation projects take decades for execution and the generated datasets are usually terabytes or petabytes in dimension.
Extra resources for Oracle Exadata Survival Guide
Example text
3, there are 393 functions that qualify as offloadable. The V$SQLFN_ METADATA view indicates offloadable functions through the OFFLOADABLE column, populated with YES for qualifying functions. Virtual columns—columns where the values are computed from other columns in the same table—are also offloadable, even though the values in those columns are dynamically generated at query time, so tables that have them are still eligible for Smart Scans. 28 Chapter 3 Storage Indexes Storage indexes may be the most misunderstood and confusing part of Exadata.
No mention of storage indexes appears in the execution plan output. The More, the Merrier Data distribution plays a large part in storage index performance, but that’s not the only data-related area that can impact Smart Scan execution and, as a result, storage index usage. Table size can also determine whether a storage index can be utilized. Serial direct path reads are generally utilized for large objects; small tables rarely trigger Smart Scans. How big does a table have to be to trigger a Smart Scan, and thus use a storage index?
In addition, the redundancy in ASM places the redundant data on a different storage cell from the primary source. This allows Exadata to lose a storage cell or apply patches in a rolling manner and not lose access to data. Patching and software upgrades are probably the most likely reasons for storage indexes to be built, as CELLSRV needs to be stopped before some patching operations or software upgrades can begin. The size and scope of patching or upgrades will determine the fate of the storage indexes: database server patching/upgrades won’t touch the storage cells, so storage indexes will remain intact, and patching/upgrades involving the storage tier or the entire Exadata machine will drop storage indexes.