LEADER 07666nam 22007815 450 001 9910300645503321 005 20200701103727.0 010 $a9781430262428 010 $a1430262427 024 7 $a10.1007/978-1-4302-6242-8 035 $a(CKB)3710000000467616 035 $a(EBL)4177935 035 $a(SSID)ssj0001546741 035 $a(PQKBManifestationID)16141415 035 $a(PQKBTitleCode)TC0001546741 035 $a(PQKBWorkID)14796179 035 $a(PQKB)11050749 035 $a(DE-He213)978-1-4302-6242-8 035 $a(MiAaPQ)EBC4177935 035 $a(PPN)18845523X 035 $a(CaSebORM)9781430262428 035 $a(OCoLC)920876288 035 $a(OCoLC)ocn920876288 035 $a(EXLCZ)993710000000467616 100 $a20150829d2015 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aExpert Oracle Exadata /$fby Martin Bach, Kristofferson Arao, Andy Colvin, Frits Hoogland, Kerry Osborne, Randy Johnson, Tanel Poder 205 $a2nd ed. 2015. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2015. 215 $a1 online resource (661 p.) 225 1 $aExpert's Voice in Oracle 300 $aIncludes index. 311 08$a9781430262411 311 08$a1430262419 327 $aContents 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 327 $aStorage 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 327 $aExadata 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 327 $aHCC 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 327 $aAutomatic 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 327 $aMoving Target 330 $aExpert 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. If you're new to Exadata, you'll soon learn that it embodies a change in how you think about and manage relational databases. A key part of that change lies in the concept of offloading SQL processing to the storage layer. In addition there is Oracle's engineering effort in creating a powerful platform for both consolidation and transaction processing. The resulting value proposition in the form of Exadata has truly been a game-changer. Expert Oracle Exadata, 2nd Edition provides a look at the internals and how the combination of hardware and software that comprise Exadata actually work. Authors include Martin Bach, Andy Colvin, and Frits Hoogland, with contributions from Karl Arao, and built on the foundation laid by Kerry Osborne, Randy Johnson, and Tanel Poder in the first edition. They share their real-world experience gained through a great many Exadata implementations, possibly more than any other group of experts today. Always their goal is toward helping you advance your career through success with Exadata in your own environment. This book is intended for readers who want to understand what makes the platform tick and for whom?"how" it does what it is does is as important as what it does. By being exposed to the features that are unique to Exadata, you will gain an understanding of the mechanics that will allow you to fully benefit from the advantages that the platform provides. This book changes how you think about managing SQL performance and processing. It provides a roadmap to successful Exadata implementation. And it removes the "black box" mystique. You'll learn how Exadata actually works and be better able to manage your Exadata engineered systems in support of your business. 410 0$aExpert's voice in Oracle. 606 $aDatabase management 606 $aData structures (Computer science) 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 606 $aData Storage Representation$3https://scigraph.springernature.com/ontologies/product-market-codes/I15025 615 0$aDatabase management. 615 0$aData structures (Computer science) 615 14$aDatabase Management. 615 24$aData Storage Representation. 676 $a005.7565 700 $aBach$b Martin$4aut$4http://id.loc.gov/vocabulary/relators/aut$0926166 702 $aArao$b Kristofferson$4aut$4http://id.loc.gov/vocabulary/relators/aut 702 $aColvin$b Andy$4aut$4http://id.loc.gov/vocabulary/relators/aut 702 $aHoogland$b Frits$4aut$4http://id.loc.gov/vocabulary/relators/aut 702 $aOsborne$b Kerry$4aut$4http://id.loc.gov/vocabulary/relators/aut 702 $aJohnson$b Randy$4aut$4http://id.loc.gov/vocabulary/relators/aut 702 $aPoder$b Tanel$4aut$4http://id.loc.gov/vocabulary/relators/aut 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910300645503321 996 $aExpert Oracle Exadata$92202153 997 $aUNINA