Oracle Exadata Survival Guide (Expert's Voice in Oracle)
Format: PDF / Kindle (mobi) / ePub
Oracle Exadata Survival Guide is a hands-on guide for busy Oracle database administrators who are migrating their skill sets to Oracle's Exadata database appliance. The book covers the concepts behind Exadata, and the available configurations for features such as smart scans, storage indexes, Smart Flash Cache, hybrid columnar compression, and more. You'll learn about performance metrics and execution plans, and how to optimize SQL running in Oracle's powerful, new environment. The authors also cover migration from other servers.
Oracle Exadata is fast becoming the standard for large installations such as those running data warehouse, business intelligence, and large-scale OLTP systems. Exadata is like no other platform, and is new ground even for experienced Oracle database administrators. The Oracle Exadata Survival Guide helps you navigate the ins and outs of this new platform, de-mystifying this amazing appliance and its exceptional performance. The book takes a highly practical approach, not diving too deeply into the details, but giving you just the right depth of information to quickly transfer your skills to Oracle's important new platform.
- Helps transfer your skills to the platform of the future
- Covers the important ground without going too deep
- Takes a practical and hands-on approach to everyday tasks
What you’ll learn
- Learn the components and basic architecture of an Exadata machine
- Reduce data transfer overhead by processing queries in the storage layer
- Examine and take action on Exadata-specific performance metrics
- Deploy Hybrid Columnar Compression to reduce storage and I/O needs
- Create worry-free migrations from existing databases into Exadata
- Understand and address issues specific to ERP migrations
Who this book is for
Oracle Exadata Survival Guide is for the busy enterprise Oracle DBA who has suddenly been thrust into the Exadata arena. Readers should have a sound grasp of traditional Oracle database administration, and be prepared to learn new aspects that are specific to the Exadata appliance.
Some cached segments cannot be mapped to an object name. UNDO segments may be found in the Smart Flash Cache, with object id values greater than four billion. 69 Chapter 5 Parallel Query Unlike other areas of Exadata, parallel query execution uses the same Oracle Release 11.2 functionality as non-Exadata systems. Because Exadata is, at its heart, a data-warehousing system, and efficient handling and processing of data-warehouse workloads was a primary design goal, parallel query processing is.
Slaves should be employed for a parallelized query. With this mechanism, the parallelism can go down dramatically, depending on the system resources in use at the moment the decision is made, which is the time the execution starts. Statements can go from having 16 or more parallel slaves for one execution to having absolutely none the next time the same statement is executed. Remember that once the degree of parallelism (DOP) is set, it cannot be altered; the statement must run to completion at.
The previous compressed update) SQL> -SQL> update emp set sal=sal*1.08 where empno > 7350; 14680064 rows updated. Elapsed: 00:20:40.64 SQL> SQL> commit; Commit complete. Elapsed: 00:00:00.01 SQL> SQL> -SQL> -- Current compression level and storage SQL> -SQL> -- Looks like the storage after the second SQL> -- update to the HCC compressed data 106 Chapter 6 ■ Compression SQL> -SQL> select table_name, compression, compress_for 2 from user_tables; TABLE_NAME COMPRESS COMPRESS_FOR.
Idle Cell manager cancel work request Other Cell smart flash unkeep Other Cell worker online completion Other Cell worker retry Other Cell manager closing cell System I/O Cell manager discovering disks System I/O Cell manager opening cell System I/O Cell smart incremental backup System I/O Cell smart restore from backup System I/O Cell list of blocks physical read User I/O Cell multiblock physical read User I/O Cell single block physical read User I/O Cell smart file.
CLUSTER | COL$ | 1 | 29 | 1 (0)| 00:00:01 | |* 14 | INDEX UNIQUE SCAN | I_OBJ# | 1 | | 0 (0)| 00:00:01 | |* 15 | TABLE ACCESS CLUSTER | COLTYPE$ | 1 | 26 | 1 (0)| 00:00:01 | |* 16 | TABLE ACCESS BY INDEX ROWID | OBJ$ | 1 | 9 | 2 (0)| 00:00:01 | |* 17 | INDEX RANGE SCAN | I_OBJ3 | 1 | | 1 (0)| 00:00:01 | |* 18 | INDEX RANGE SCAN | I_USER2 | 1 | 22 | 1 (0)| 00:00:01 | |* 19 | INDEX RANGE SCAN | I_USER2 | 1 | 4 | 1 (0)| 00:00:01 | |* 20 | INDEX RANGE SCAN | I_HH_OBJ#_INTCOL# | 1 | 9 | 1 (0)|.