Oracle Exadata survival guide
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, S...
| Main Authors: | , |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Berkeley, California
Apress
2013
|
| Series: | The expert's voice in Oracle
|
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- At a Glance; Chapter 1: Exadata Basics; What Is Exadata?; Available Configurations; Storage; Smart Flash Cache; Even More Storage; Things to Know; Chapter 2: Smart Scans and Offloading; Smart Scans; Plans and Metrics; Smart Scan Optimizations; Column Projection; Predicate Filtering; Basic Joins; Offloading Functions; Virtual Columns; Things to Know; Chapter 3: Storage Indexes; An Index That Isn't; Don't Look Here; I Used It; Or Maybe I Didn't; Execution Plan Doesn't Know; The More, the Merrier; NULLs; Needing to "Rebuild "; Things to Know; Chapter 4: Smart Flash Cache; Flash Me
- Includes bibliographical references and index
- Chapter 7: Exadata Cell Wait EventsAvailable Nowhere Else; Cell Events; Triggering Events; User I/O Events; Cell Smart Table Scan; Cell Smart Index Scan; Cell Single-Block Physical Read; Cell Multiblock Physical Read; Cell List of Blocks Physically Read; Cell Smart File Creation; Cell Statistics Gather; System I/O Events; Cell Smart Incremental Backup; Cell Smart Restore from Backup; Idle Class/Other Class; Cell Smart Flash Unkeep; Things to Know; Chapter 8: Measuring Performance; Measure Twice, Cut Once; Smart Scans, Again; Performance Counters and Metrics; Dynamic Counters
- How It WorksLogging We Will Go; It's a Disk; Monitoring; Storage Server Tools; Database Server Tools; What a Performer; Things to Know; Chapter 5: Parallel Query; Getting into the Queue; Old School; The New Method; Control Issues; Necessary Settings; My Friend Auto; Calibrate Me; Make It So; Do It in Memory; Things to Know; Chapter 6: Compression; How Can I Compress Thee; Basic; OLTP; Hybrid Columnar Compression (HCC); QUERY; ARCHIVE; The Nuts and Bolts of HCC; Performance; When You Load; When You Query; When You Update; Ratios-What to Expect; What Oracle Thinks; What You Get; Things to Know
- When to Use Them, and HowLet Me Explain; Performance Counter Reference; cell blocks helped by commit cache; cell blocks helped by minscn optimization; cell commit cache queries; cell blocks processed by cache layer; cell blocks processed by data layer; cell blocks processed by index layer; cell blocks processed by txn layer; cell flash cache read hits; cell index scans; cell IO uncompressed bytes; cell num fast response sessions; cell num fast response sessions continuing to smart scan; cell num smart IO sessions using passthru mode due to _______
- Cell physical IO bytes sent directly to DB node to balance CPU usagechained rows process ed by cell; chained rows rejected by cell; chained rows skipped by cell; SQL Statement Performance; Things to Know; Chapter 9: Storage Cell Monitoring; Talking to the Storage Cells; Where Shall I Go?; What Shall I Do?; What's in a Name?; Monitoring Basics; As cellmonitor; As celladmin; Things to Know; Chapter 10: Monitoring Exadata; The Database Layer; Are We There Yet?; Real-Time SQL Monitoring Reports; Using GVSQL and GVSQLSTATS (But That's Not All); The Storage Cells; The Command Line; OEM.