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...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New York :
Apress
2013.
|
| Edición: | 1st ed. 2013. |
| Colección: | Expert's voice in Oracle.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629636706719 |
Tabla de Contenidos:
- ""Contents at a Glance""; ""Contents""; ""About the Authors""; ""About the Technical Reviewer""; ""Acknowledgments""; ""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""; ""How It Works""; ""Logging 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""; ""Chapter 7: Exadata Cell Wait Events""; ""Available 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""; ""When to Use Them, and How""; ""Let 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 usage""
- ""chained rows process ed by cell""
