Oracle Exadata Survival Guide (Expert's Voice In Oracle)

• Contents at a Glance
• Contents
• About the Authors
• About the Technical Reviewer
• Acknowledgments
• Chapter 1: Exadata Basics
  • What Is Exadata?
  • Available Configurations
  • Storage
  • Smart Flash Cache
  • Even More Storage
  • Things to Know
• Chapter 2: Smart Scans and Offloading
  • Smart Scans
  • Plans and Metrics
  • Smart Scan Optimizations
  • Column Projection
  • Predicate Filtering
  • Basic Joins
  • Offloading Functions
  • Virtual Columns
  • Things to Know
• Chapter 3: Storage Indexes
  • An Index That Isn’t
  • Don’t Look Here
  • I Used It
  • Or Maybe I Didn’t
  • Execution Plan Doesn’t Know
  • The More, the Merrier
  • NULLs
  • Needing to “Rebuild ”
  • Things to Know
• Chapter 4: Smart Flash Cache
  • Flash Me
  • How It Works
  • Logging We Will Go
  • It’s a Disk
  • Monitoring
    • Storage Server Tools
    • Database Server Tools
  • What a Performer
  • Things to Know
• Chapter 5: Parallel Query
  • Getting into the Queue
  • Old School
  • The New Method
  • Control Issues
  • Necessary Settings
  • My Friend Auto
    • Calibrate Me
    • Make It So
  • Do It in Memory
  • Things to Know
• Chapter 6: Compression
  • How Can I Compress Thee
    • Basic
    • OLTP
    • Hybrid Columnar Compression (HCC)
      • QUERY
      • ARCHIVE
  • The Nuts and Bolts of HCC
  • Performance
    • When You Load
    • When You Query
    • When You Update
  • Ratios—What to Expect
    • What Oracle Thinks
    • What You Get
  • Things to Know
• Chapter 7: Exadata Cell Wait Events
  • Available Nowhere Else
    • Cell Events
  • Triggering Events
  • User I/O Events
    • Cell Smart Table Scan
    • Cell Smart Index Scan
    • Cell Single-Block Physical Read
    • Cell Multiblock Physical Read
    • Cell List of Blocks Physically Read
    • Cell Smart File Creation
    • Cell Statistics Gather
  • System I/O Events
    • Cell Smart Incremental Backup
    • Cell Smart Restore from Backup
  • Idle Class/Other Class
    • Cell Smart Flash Unkeep
  • Things to Know
• Chapter 8: Measuring Performance
  • Measure Twice, Cut Once
  • Smart Scans, Again
  • Performance Counters and Metrics
    • Dynamic Counters
    • When to Use Them, and How
    • Let Me Explain
    • Performance Counter Reference
      • cell blocks helped by commit cache
      • cell blocks helped by minscn optimization
      • cell commit cache queries
      • cell blocks processed by cache layer
      • cell blocks processed by data layer
      • cell blocks processed by index layer
      • cell blocks processed by txn layer
      • cell flash cache read hits
      • cell index scans
      • cell IO uncompressed bytes
      • cell num fast response sessions
      • cell num fast response sessions continuing to smart scan
      • cell num smart IO sessions using passthru mode due to _______
      • cell physical IO bytes sent directly to DB node to balance CPU usage
      • chained rows process ed by cell
      • chained rows rejected by cell
      • chained rows skipped by cell
    • SQL Statement Performance
  • Things to Know
• Chapter 9: Storage Cell Monitoring
  • Talking to the Storage Cells
    • Where Shall I Go?
    • What Shall I Do?
  • What’s in a Name?
  • Monitoring Basics
    • As cellmonitor
    • As celladmin
  • Things to Know
• Chapter 10: Monitoring Exadata
  • The Database Layer
  • Are We There Yet?
    • Real-Time SQL Monitoring Reports
    • Using GV$SQL and GV$SQLSTATS (But That’s Not All)
  • The Storage Cells
    • The Command Line
    • OEM
    • Adding the O/S Metrics
  • Things to Know
• Chapter 11: Storage Reconfiguration
  • I Wish We Had More…
  • Redistributing the Wealth
    • Prepare
    • Act
      • Act 1
      • Act 2
      • Act 3
    • Restore
    • Act 4
  • Things to Know
• Chapter 12: Migrating Databases to Exadata
  • Getting Physical
    • Using Backups
    • Transporting Tablespaces
    • Please Stand By
    • Post-migration Stuff
  • That’s Logical
    • Export and Import
    • Replication
    • Using Database Links
  • Things to Know
• Chapter 13: ERP Setup—a Practical Guide
  • Cloning the Oracle Home
  • The SCAN Listener
  • Creating a Database
  • Setting Up the Listener
  • Data Migration
  • Environment Configuration
  • Setting the Environment
  • “My Oracle Support ” Notes
  • Things to Know
• Chapter 14: Final Thoughts
  • You’ve Come Far, Pilgrim
  • To DMA or Not to DMA
  • What You Don’t Know, You Can Look Up
  • Things to Know
• Index