Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Expert Consolidation in Oracle Database 12c / / by Martin Bach
| Expert Consolidation in Oracle Database 12c / / by Martin Bach |
| Autore | Bach Martin |
| Edizione | [1st ed. 2013.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2013 |
| Descrizione fisica | 1 online resource (XXI, 488 p. 341 illus.) |
| Disciplina | 005.74 |
| Collana | Expert's Voice in Oracle |
| Soggetto topico |
Database management
Database Management |
| ISBN |
9781430244295
1430244291 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910735388503321 |
Bach Martin
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Expert Oracle Exadata / / by Martin Bach, Kristofferson Arao, Andy Colvin, Frits Hoogland, Kerry Osborne, Randy Johnson, Tanel Poder
| Expert Oracle Exadata / / by Martin Bach, Kristofferson Arao, Andy Colvin, Frits Hoogland, Kerry Osborne, Randy Johnson, Tanel Poder |
| Autore | Bach Martin |
| Edizione | [2nd ed. 2015.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 |
| Descrizione fisica | 1 online resource (661 p.) |
| Disciplina | 005.7565 |
| Collana | Expert's Voice in Oracle |
| Soggetto topico |
Database management
Data structures (Computer science) Database Management Data Storage Representation |
| ISBN |
9781430262428
1430262427 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents 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 Moving Target |
| Record Nr. | UNINA-9910300645503321 |
|
Bach Martin
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||