Expert Oracle exadata /

Throughout history, advances in technology have come in spurts. A single great idea can often spur rapid change as the idea takes hold and is propagated, often in totally unexpected directions. Exadata embodies such a change in how we think about and manage relational databases. The key change lies...

Full description

Saved in:
Bibliographic Details
Main Author: Osborne, Kerry.
Other Authors: Johnson, Randy., Põder, Tanel.
Format: eBook
Published: New York : Apress, 2011.
Series:Expert's voice in Oracle.
Online Access:CONNECT
LEADER 07719cam a2200685 a 4500
001 in00006049778
006 m o d
007 cr cnu---unuuu
008 111024s2011 nyua o 001 0 eng d
005 20220718131442.1
035 |a 1WRLDSHRocn758346761 
040 |a GW5XE  |b eng  |e pn  |c GW5XE  |d UMI  |d E7B  |d COO  |d OCLCQ  |d ZCU  |d B24X7  |d EBLCP  |d DEBSZ  |d OCLCQ  |d IDEBK  |d OCLCF  |d OCLCQ  |d BEDGE  |d OCLCQ  |d MEAUC  |d YDXCP  |d OCLCQ  |d TXI  |d OCLCQ  |d Z5A  |d LIV  |d OCLCQ  |d MERUC  |d ESU  |d OCLCQ  |d VT2  |d IOG  |d OCLCO  |d CEF  |d DEHBZ  |d OCLCQ  |d OCLCO  |d INT  |d U3W  |d AU@  |d OCLCQ  |d OCLCO  |d WYU  |d YOU  |d OCLCQ  |d UKAHL  |d OL$  |d OCLCO  |d OCLCQ  |d OCLCO  |d W2U  |d DCT  |d ERF  |d SFB  |d OCLCQ  |d BRF  |d OCLCQ  |d COM  |d OCLCO 
019 |a 757516307  |a 771225137  |a 857251235  |a 966385508  |a 1005832101  |a 1058565410  |a 1064203565  |a 1066582427  |a 1086527359  |a 1087304947  |a 1110818479  |a 1112532775  |a 1125458953  |a 1129359779  |a 1136441331  |a 1204073730  |a 1295611066 
020 |a 9781430233930  |q (electronic bk.) 
020 |a 1430233931  |q (electronic bk.) 
020 |z 9781430233923 
020 |z 1430233923 
024 7 |a 10.1007/978-1-4302-3393-0  |2 doi 
035 |a (OCoLC)758346761  |z (OCoLC)757516307  |z (OCoLC)771225137  |z (OCoLC)857251235  |z (OCoLC)966385508  |z (OCoLC)1005832101  |z (OCoLC)1058565410  |z (OCoLC)1064203565  |z (OCoLC)1066582427  |z (OCoLC)1086527359  |z (OCoLC)1087304947  |z (OCoLC)1110818479  |z (OCoLC)1112532775  |z (OCoLC)1125458953  |z (OCoLC)1129359779  |z (OCoLC)1136441331  |z (OCoLC)1204073730  |z (OCoLC)1295611066 
037 |a CL0500000114  |b Safari Books Online 
050 4 |a QA76.73.S67  |b O83 2011eb 
082 0 4 |a 005.74  |2 23 
049 |a TXMM 
100 1 |a Osborne, Kerry. 
245 1 0 |a Expert Oracle exadata /  |c Kerry Osborne, Randy Johnson, Tanel Põder. 
260 |a New York :  |b Apress,  |c 2011. 
300 |a 1 online resource (xxiv, 562 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file 
347 |b PDF 
490 1 |a The Expert's voice in Oracle 
588 0 |a Print version record. 
520 |a Throughout history, advances in technology have come in spurts. A single great idea can often spur rapid change as the idea takes hold and is propagated, often in totally unexpected directions. Exadata embodies such a change in how we think about and manage relational databases. The key change lies in the concept of offloading SQL processing to the storage layer. That concept is a huge win, and its implementation in the form of Exadata is truly a game changer. Expert Oracle Exadata will give you a look under the covers at how the combination of hardware and software that comprise Exadata actually work. Authors Kerry Osborne, Randy Johnson, and Tanel Põder share their real-world experience, gained through multiple Exadata implementations with the goal of opening up the internals of the Exadata platform. 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. Changes the way you think about managing SQL performance and processing Provides a roadmap to laying out the Exadata platform to best support your existing systems Dives deeply into the internals, removing the "black box" mystique and showing how Exadata actually works 
505 0 |a Title Page; Copyright Page; Contents at a Glance; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; The Intended Audience; How We Came to Write This Book; A Moving Target; Thanks to the Unofficial Editors; Who Wrote That?; Online Resources; A Note on "Kevin Says"; How We Tested; Schemas and Tables; Good Luck; 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 X2-2. 
505 8 |a Exadata Database Machine X2-8Upgrades; Hardware Components; Operating Systems; Database 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; Simple Joins (Bloom Filters); Function Offloading; Compression/Decompression; Encryption/Decryption; Virtual Columns; Data Mining Model Scoring; Non-Smart Scan Offloading; Smart File Creation. 
505 8 |a RMAN Incremental BackupsRMAN Restores; Smart Scan Prerequisites; Full Scans; Direct Path Reads; Exadata Storage; Smart Scan Disablers; Simply Unavailable; Reverting to Block Shipping; Skipping Some Offloading; How to Verify That Smart Scan is Happening; 10046 Trace; Performance Statistics (vsessstat); Offload Eligible Bytes; SQL Monitoring; Parameters; Summary; CHAPTER 3 Hybrid Columnar Compression; Oracle Storage Review; Oracle Compression Mechanisms; BASIC; OLTP; HCC; HCC Mechanics; HCC Performance; Load Performance; Query Performance; DML Performance; Expected Compression Ratios. 
505 8 |a Compression AdvisorReal 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; 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; Storage Software Parameters; Behavior. 
505 8 |a PerformanceSpecial Optimization for Nulls; Physical Distribution of Values; Potential Issues; Incorrect Results; Moving Target; Partition Size; Incompatible Coding Techniques; Summary; CHAPTER 5 Exadata Smart Flash Cache; Hardware; Cache vs. Flash Disk; Using Flash Memory as Cache; How ESFC is Created; Controlling ESFC Usage; Monitoring; At the Storage Layer; At the Database Layer; Performance; Summary; CHAPTER 6 Exadata Parallel Operations; Parameters; Parallelization at the Storage Tier; Auto DOP; Operation and Configuration; I/O Calibration; Auto DOP Wrap Up; Parallel Statement Queuing. 
546 |a English. 
590 |a O'Reilly Online Learning Platform: Academic Edition (SAML SSO Access) 
630 0 0 |a Oracle (Computer file) 
630 0 7 |a Oracle (Computer file)  |2 blmlsh 
630 0 7 |a Oracle (Computer file)  |2 fast  |0 (OCoLC)fst01363816 
650 0 |a SQL/ORACLE (Computer program language) 
650 0 |a Database management. 
700 1 |a Johnson, Randy. 
700 1 |a Põder, Tanel. 
773 0 |t Springer eBooks 
776 0 8 |i Print version:  |a Osborne, Kerry.  |t Expert Oracle exadata.  |d New York : Apress, 2011  |z 9781430233923  |w (OCoLC)709668118 
830 0 |a Expert's voice in Oracle. 
856 4 0 |u  |z CONNECT  |3 O'Reilly  |t 0 
949 |a ho0 
994 |a 92  |b TXM 
998 |a wi  |d z 
999 f f |s 606ca2a2-d6f1-4bf2-a754-ea04974f2b42  |i 83fdc3dc-2cb7-4804-a194-9d1ee246f808  |t 0 
952 f f |a Middle Tennessee State University  |b Main  |c James E. Walker Library  |d Electronic Resources  |t 0  |e QA76.73.S67 O83 2011eb  |h Library of Congress classification 
856 4 0 |3 O'Reilly  |t 0  |u  |z CONNECT