Borrow it
Coverart for item
The Resource Expert Oracle exadata, Kerry Osborne, Randy Johnson, Tanel Põder

Expert Oracle exadata, Kerry Osborne, Randy Johnson, Tanel Põder

Creator
Contributor
Summary
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
Language
eng
Work
Publication
Extent
1 online resource (xxiv, 562 pages)
Contents
  • 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
  • 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
  • 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
  • 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
  • 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
Isbn
9781430233930
Link
Instance
Label
Expert Oracle exadata
Title
Expert Oracle exadata
Statement of responsibility
Kerry Osborne, Randy Johnson, Tanel Põder
Creator
Contributor
Subject
Genre
Language
eng
Summary
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
Member of
Is part of
Cataloging source
GW5XE
http://library.link/vocab/creatorName
Osborne, Kerry
Dewey number
005.74
Illustrations
illustrations
Index
index present
Language note
English
LC call number
QA76.73.S67
LC item number
O83 2011eb
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
  • Johnson, Randy
  • Põder, Tanel
Series statement
The Expert's voice in Oracle
http://library.link/vocab/subjectName
  • SQL/ORACLE (Computer program language)
  • Database management
  • Informatique
  • Database management
  • SQL/ORACLE (Computer program language)
Label
Expert Oracle exadata, Kerry Osborne, Randy Johnson, Tanel Põder
Link
Instantiates
Publication
Antecedent source
unknown
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • 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
  • 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
  • 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
  • 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
  • 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
Dimensions
unknown
Extent
1 online resource (xxiv, 562 pages)
File format
unknown
Form of item
online
Isbn
9781430233930
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Note
O'Reilly
Other control number
10.1007/978-1-4302-3393-0
Other physical details
illustrations
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000114
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)758346761
Label
Expert Oracle exadata, Kerry Osborne, Randy Johnson, Tanel Põder
Link
Publication
Antecedent source
unknown
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
  • 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
  • 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
  • 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
  • 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
  • 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
Dimensions
unknown
Extent
1 online resource (xxiv, 562 pages)
File format
unknown
Form of item
online
Isbn
9781430233930
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Note
O'Reilly
Other control number
10.1007/978-1-4302-3393-0
Other physical details
illustrations
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000114
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)758346761

Subject

Genre

Member of

Library Locations

  • Anza LibraryBorrow it
    550 37th Avenue, San Francisco, CA, 94121, US
    37.778535 -122.497218
  • Bayview/Linda Brooks-Burton LibraryBorrow it
    5075 3rd Street, San Francisco, CA, 94124, US
    37.732534 -122.391121
  • Bernal Heights LibraryBorrow it
    500 Cortland Avenue, San Francisco, CA, 94110, US
    37.738862 -122.416132
  • Bookmobiles / Mobile OutreachBorrow it
    San Francisco, CA, US
  • Chinatown/Him Mark Lai LibraryBorrow it
    1135 Powell Street, San Francisco, CA, 94108, US
    37.795248 -122.410239
  • Eureka Valley/Harvey Milk Memorial LibraryBorrow it
    1 Jose Sarria Court, San Francisco, CA, 94114, US
    37.764084 -122.431821
  • Excelsior LibraryBorrow it
    4400 Mission Street, San Francisco, CA, 94112, US
    37.727127 -122.433284
  • Glen Park LibraryBorrow it
    2825 Diamond Street, San Francisco, CA, 94131, US
    37.733969 -122.433723
  • Golden Gate Valley LibraryBorrow it
    1801 Green Street, San Francisco, CA, 94123, US
    37.797819 -122.428950
  • Ingleside LibraryBorrow it
    1298 Ocean Ave, San Francisco, CA, 94112, US
    37.724132 -122.456251
  • Marina LibraryBorrow it
    1890 Chestnut Street, San Francisco, CA, 94123, US
    37.801325 -122.434154
  • Merced LibraryBorrow it
    155 Winston Drive, San Francisco, CA, 94132, US
    37.726735 -122.474482
  • Mission Bay LibraryBorrow it
    960 4th Street, San Francisco, CA, 94158, US
    37.775330 -122.393195
  • Mission LibraryBorrow it
    300 Bartlett St, San Francisco, CA, 94110, US
    37.751989 -122.419843
  • Noe Valley/Sally Brunn LibraryBorrow it
    451 Jersey Street, San Francisco, CA, 94114, US
    37.750180 -122.435116
  • North Beach LibraryBorrow it
    850 Columbus Avenue, San Francisco, CA, 94133, US
    37.802585 -122.413280
  • Ocean View LibraryBorrow it
    345 Randolph Street, San Francisco, CA, 94132, US
    37.714138 -122.466002
  • Ortega LibraryBorrow it
    3223 Ortega Street, San Francisco, CA, 94122, US
    37.751163 -122.498094
  • Park LibraryBorrow it
    1833 Page Street, San Francisco, CA, 94117, US
    37.770300 -122.451046
  • Parkside LibraryBorrow it
    1200 Taraval Street, San Francisco, CA, 94116, US
    37.743130 -122.479330
  • Portola LibraryBorrow it
    380 Bacon Street, San Francisco, CA, 94134, US
    37.727098 -122.406361
  • Potrero LibraryBorrow it
    1616 20th Street, San Francisco, CA, 94107, US
    37.760122 -122.397653
  • Presidio LibraryBorrow it
    3150 Sacramento Street, San Francisco, CA, 94115, US
    37.788875 -122.444892
  • Richmond/Senator Milton Marks LibraryBorrow it
    351 9th Ave, San Francisco, CA, 94118, US
    37.781855 -122.468054
  • San Francisco Public LibraryBorrow it
    100 Larkin Street, San Francisco, CA, 94102, US
    37.779376 -122.415795
  • Sunset LibraryBorrow it
    1305 18th Ave., San Francisco, CA, 94122, US
    37.763354 -122.476307
  • Visitacion Valley LibraryBorrow it
    201 Leland Avenue, San Francisco, CA, 94134, US
    37.712695 -122.407913
  • West Portal LibraryBorrow it
    190 Lenox Way, San Francisco, CA, 94127, US
    37.741341 -122.465883
  • Western AdditionBorrow it
    1550 Scott Street, San Francisco, CA, 94115, US
    37.784121 -122.437503

Library Links

Structured data from the Bibframe namespace is licensed under the Creative Commons Attribution 4.0 International License by San Francisco Public Library. Additional terms may apply to data associated with third party namespaces.