Cargando…
Expert Oracle exadata /
Expert Oracle Exadata, 2nd Edition opens up the internals of Oracle's Exadata platform so that you can fully benefit from the most performant and scalable database hardware appliance capable of running Oracle Database. This edition is fully-updated to cover Exadata 5-2 and Oracle Database 12c....
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[Berkeley, CA] :
Apress,
[2015]
|
| Edición: | Second edition. |
| Colección: | Expert's voice in Oracle.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- At a Glance; Contents; About the Authors; Acknowledgments; Introduction; Chapter 1: What Is Exadata?; An Overview of Exadata; History of Exadata; Alternative Views of What Exadata Is; Data Warehouse Appliance; OLTP Machine; Consolidation Platform; Configuration Options; Exadata Database Machine X5-2 ; Exadata Database Machine X4-8 ; Exadata Storage Expansion Rack X5- 2 ; Upgrades; Hardware Components; Operating Systems; Database Servers; Storage Servers; InfiniBand; Flash Cache; Disks; Bits and Pieces; Software Components; Database Server Software.
- Storage Server Software Software Architecture; Summary; Chapter 2: Offloading / Smart Scan; Why Offloading Is Important; What Offloading Includes; Column Projection; Predicate Filtering; Storage Indexes and Zone Maps; Simple Joins (Bloom Filters); Function Offloading; Compression/Decompression; Encryption/Decryption; Virtual Columns; Support for LOB offloading; JSON Support and Offloading; Data Mining Model Scoring; Non-Smart Scan Offloading; Smart/Fast File Creation; RMAN Incremental Backups; RMAN Restores; Smart Scan Prerequisites; Full Scans; Direct Path Reads.
- Exadata Storage Smart Scan Disablers; Simply Unavailable; Reverting to Block Shipping; Skipping Some Offloading; Skipping Offloading silently; How to Verify That Smart Scan Is Happening; 10046 Trace; Session Performance Statistics; Offload Eligible Bytes; SQL Monitoring; Parameters; Summary; Chapter 3: Hybrid Columnar Compression; Oracle Storage Review; Disassembling the Oracle Block; Compression Mechanics; BASIC Compression; OLTP Compression; Hybrid Columnar Compression; What Does the "Hybrid" in "Hybrid Columnar Compression" Mean?; Making Use of Hybrid Columnar Compression.
- HCC Internals What Happens When You Create a HCC Compressed Table?; HCC Performance; Load Performance ; Query Performance ; DML Performance ; Expected Compression Ratios; Compression Advisor; Real-World Examples; Custom Application Data; Telecom Call Detail Data; Financial Data; Retail Sales Data; Summary of the Real-World Examples; Restrictions/Challenges; Moving Data to a Non-Exadata Platform; Disabling Serial Direct Path Reads; Locking Issues; Single Row Access; Common Usage Scenarios; Automatic Data Optimization; What Is Data Lifecycle Management?; Compression.
- Automatic Data Optimization vs. Manual Lifecycle Management Example Use Cases for ADO; Enable ILM for Storage Tiering ; Enable ILM for Compression ; Summary; Chapter 4: Storage Indexes; Structure ; Monitoring Storage Indexes; Database Statistics; Tracing ; Monitoring Wrap-Up; Controlling Storage Indexes; -kcfis-storageidx- disabled ; -kcfis-storageidx-diag- mode ; -cell-storidx- mode ; -cell-storidx-minmax- enabled ; Storage Software Parameters ; Behavior; Performance; Special Optimization for Nulls; Physical Distribution of Values ; Potential Issues; Incorrect Results.