You are previewing Running Applications on Oracle Exadata.
O'Reilly logo
Running Applications on Oracle Exadata

Book Description

Maximize Application Performance on Oracle Exadata

Written by an enterprise architect specializing in applications on Oracle's engineered systems, Running Applications on Oracle Exadata: Tuning Tips & Techniques reveals proven methods for configuring and tuning Oracle Exadata to achieve peak results from applications. You'll get complete details on application migration, consolidation, and administration. Deliver unparalleled enterprise application performance on Oracle Exadata using the best practices provided in this Oracle Press guide.

  • Understand Oracle Exadata architecture, hardware components, and software features
  • Achieve peak performance from online transaction processing (OLTP) systems
  • Size Oracle Exadata for applications using comparative and predictive methods
  • Migrate and consolidate applications to Oracle Exadata
  • Monitor, manage, and administer all Oracle Exadata components to ensure high availability and performance
  • Develop and implement a backup and recovery strategy
  • Learn best practices for running applications on Oracle Exadata

Code examples in the book are available for download at OraclePressBooks.com

Table of Contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Dedication
  5. About the Technical Editor
  6. Contents at a Glance
  7. Contents
  8. Acknowledgments
  9. Introduction
  10. 1 Exadata Architecture
    1. A Brief History
      1. Oracle Database Machine V1
      2. Oracle Database Machine V2
      3. Oracle Exadata Database Machine X2
      4. Oracle Exadata Database Machine X3
      5. Oracle Exadata Database Machine X4
    2. Exadata Architecture
      1. Database Servers
      2. Exadata Storage Servers or Storage Cells
      3. InfiniBand
    3. Exadata Configurations
      1. Xn-2 Full Rack
      2. Xn-2 Half Rack
      3. Xn-2 Quarter Rack
      4. Xn-2 Eighth Rack
      5. Xn-8 Full Rack
    4. Exadata Storage Expansion Rack
    5. Advantages of Exadata
    6. Platinum Services for Exadata
    7. Summary
  11. 2 Exadata Hardware Features
    1. Database Servers
      1. X4-2 Servers
      2. X4-8 Servers
    2. Storage Servers
      1. Exadata Storage Server X4-2
    3. InfiniBand
    4. Ethernet Network
    5. Power Distribution Units
      1. For X4-2 Machines
      2. For X4-8 Machines
    6. Environment Information
      1. X4-2 High-Capacity Disks
      2. Exadata X4-2 High-Performance Disk
      3. Exadata X4-8 High-Performance and High-Capacity Drive
    7. Summary
  12. 3 Exadata Software Features
    1. Hybrid Columnar Compression (HCC)
      1. Warehouse Compression
      2. Online Archival Compression
      3. Implementing HCC
      4. Export/Import of HCC Tables
      5. Restoring an Exadata HCC Table
    2. Smart Scans
      1. Smart Scan SQL Operations
      2. Considerations that Affect Smart Scan
      3. Querying for Smart Scan
      4. Smart Scan Metrics
      5. Queries to Capture Smart Scan
    3. Exadata Smart Flash Cache
      1. Exadata Smart Flash Cache and Read Operations
      2. Exadata Smart Flash Cache and Write Operations
      3. CELL_FLASH_CACHE Setting and Cache Hint
      4. Pinning Objects in Flash Cache
      5. Exadata Smart Flash Cache and Flash Grid Disks
      6. Monitoring Flash Usage
      7. More Exadata Smart Flash Cache Features
    4. Resource Manager
    5. Summary
  13. 4 Leveraging Exadata Features for Applications
    1. Characteristics of an OLTP System
    2. Exadata Features
      1. Write-Back Flash Cache
      2. Smart Flash Logging
      3. Flash Cache Compression
      4. Database Links Over InfiniBand
      5. Exalogic-Exadata Connectivity Using InfiniBand
      6. Configuring HugePages
    3. Summary
  14. 5 Sizing Exadata for Applications
    1. Comparative Sizing
      1. Server Models
      2. Memory
      3. Comparative Sizing Attributes to Consider
    2. Predictive Sizing
      1. Users
      2. Functionalities
      3. Application Services
      4. Batch Jobs
      5. Reporting
      6. Geography
      7. Application Growth
      8. Special Throughput Needs
      9. Predictive Sizing Attributes to Consider
      10. Predictive Sizing Questionnaire Examples
    3. Disaster Recovery Environment Sizing
    4. Nonproduction Environment Sizing
      1. Production Support/QA Environment
      2. Development, Unit Test Environment
    5. Comparative Sizing Case Study
    6. Summary
  15. 6 Migrating Applications to Exadata
    1. Planning and Preparing for Migration
    2. Migration Paths
      1. Migration Using RMAN
      2. Migration Using Data Pump Export and Import
      3. Migration Using Transportable Database (TDB)
      4. Migration Using TTS or XTTS
      5. Migration Using Oracle Data Guard
      6. Migration Using GoldenGate
    3. Summary
    4. Addendum 6.1: get_bfile.sql
    5. Addendum 6.2: get_bfile_dir.sql
  16. 7 Application Consolidation in Exadata
    1. Advantages of Server Consolidation
    2. How to Consolidate in Exadata
      1. Using Consolidation Planner
    3. Managing Resources in Exadata After Consolidation
      1. Instance Caging
      2. Database Resource Manager (DBRM)
      3. I/O Resource Manager (IORM)
      4. Other Considerations/Recommendations for Consolidation
    4. Summary
  17. 8 Monitoring Exadata
    1. Monitoring Using Enterprise Manager
      1. Monitoring Compute Nodes
      2. Monitoring ILOM
      3. Monitoring Storage Cells
      4. Monitoring InfiniBand
      5. Monitoring the Cisco Ethernet Switch, KVM, and PDUs
      6. Monitoring the Databases
      7. Monitoring SQL
    2. Monitoring from the Servers Directly
      1. OS System Log
      2. CPU Utilization
      3. Memory Utilization
      4. ILOM Events
      5. Storage Cell Metric
    3. Exachk
    4. Summary
  18. 9 Managing Exadata
    1. Starting and Stopping Exadata Machine
      1. Shut Down the Machine
      2. Start Up the Machine
    2. Operational Commands
      1. Commands Related to Power Off/Reboot
      2. Commands Related to InfiniBand
      3. Tools and Commands for Managing the Grid Infrastructure, ASM, and Database
    3. Administering Storage Cells
    4. CellCLI
    5. Managing Disks
    6. Managing Flash
    7. Monitoring Using CellCLI
    8. Distributed Command Line Interface (DCLI)
    9. Summary
    10. Addendum 9.1: Flash Cache Metrics and Descriptions
    11. Addendum 9.2: Exadata Smart Flash Log Metrics and Descriptions
    12. Addendum 9.3: Sample Commands Related to CellCLI
      1. Sample Commands Related to ALTER
      2. Sample Commands Related to CREATE
      3. Sample Commands Related to DROP
      4. Sample Commands Related to LIST
  19. 10 Exadata Backup and Recovery
    1. Database Backup
      1. Fast Recovery Area (FRA)
      2. Physical Storage Options for Backups
      3. Recovery Manager (RMAN)
    2. Storage Cells Backup
    3. Compute Nodes Backup
      1. Snapshot-Based Backup
      2. Recovering Compute Nodes with Non-customized Partitions
      3. Recovering Oracle Linux Database Server with Customized Partitions
    4. InfiniBand Switch Backup
      1. Restore an InfiniBand Switch
    5. Summary
  20. Index