You are previewing Achieving Extreme Performance with Oracle Exadata.
O'Reilly logo
Achieving Extreme Performance with Oracle Exadata

Book Description

Maximize Oracle Exadata Capabilities

Leverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and migration are included in this authoritative resource.

• Take advantage of the tightly integrated hardware and software in the Oracle Exadata Database Machine

• Work with Oracle Exadata software features, including Smart Scans, Oracle Exadata Hybrid Columnar Compression, storage indexes, Oracle Exadata Smart Flash Cache, and I/O Resource Manager

• Understand Oracle Exadata Database Machine balanced hardware architecture

• Architect, administer, and monitor Oracle Exadata Storage Servers

• Deploy data warehouses on the Oracle Exadata Database Machine

• Run online transaction processing (OLTP) workloads on the Oracle Exadata Database Machine

• Consolidate databases with and migrate databases to the Oracle Exadata Database Machine

Table of Contents

  1. Cover Page
  2. Achieving Extreme Performance with Oracle Exadata
  3. Copyright Page
  4. Dedication
  5. About the Authors
  6. Contents
  7. FOREWORD
  8. ACKNOWLEDGMENTS
  9. INTRODUCTION
  10. PART I Features and Foundations
    1. 1 Oracle and Tightly Integrated Hardware and Software Platforms
      1. A History of Appliance-like Computing Solutions
      2. Oracle’s Evolution Towards Integrated Hardware and Software
      3. Oracle Exadata Database Machine Fundamental Concepts
      4. Software Integration and the Oracle Exadata Database Machine
      5. Impact of the Platform on Personnel
      6. Future Directions
      7. Summary
    2. 2 Oracle 11g Enterprise Edition Features
      1. Data Integrity and Performance
        1. Locks and Lock Management
        2. MVRC
        3. Flashback
      2. Real Application Clusters
        1. What Is RAC?
        2. RAC and Availability
        3. RAC and Scalability
        4. Cache Fusion
        5. Allocating Resources and RAC
        6. RAC One
        7. RAC and the Exadata Database Machine
      3. Automatic Storage Management
        1. What Is ASM?
        2. ASM and Performance
        3. ASM and Availability
        4. ASM and Management
      4. Partitioning
        1. What Is Partitioning?
        2. Partitioning Types
        3. Other Benefits
        4. Partitioning and the Exadata Database Machine
      5. Parallel Execution
        1. What Is Parallel Execution?
        2. What Can Be Parallelized?
        3. How Parallelism Works
        4. Partition-wise Parallel Joins
        5. How Do You Configure Parallel Execution?
        6. Degree of Parallelism
        7. Modifying DOP
        8. Ensuring DOP
        9. Parallelism and RAC
        10. In-memory Parallel Execution
        11. Parallelism and Exadata
      6. Data Guard
        1. What Is Data Guard?
        2. How Can Data Guard Be Implemented?
        3. Data Guard and Exadata
      7. Compression
        1. What Types of Compression Does Oracle Support?
        2. SecureFiles
        3. Benefits of Compression
      8. Database Resource Manager
        1. What Is Database Resource Manager?
        2. How Does Database Resource Manager Work?
        3. What Can Database Resource Manager Affect?
        4. Other Factors
        5. How Does Database Resource Manager Work with Exadata?
      9. Analysis Capabilities
        1. Analytic Functions
        2. Data Mining
      10. Enterprise Manager
      11. Data Movement
        1. Utilities
        2. Features
      12. Operating Systems
        1. Solaris Support
        2. Oracle Linux
      13. Other Oracle Database 11g Features
        1. Materialized Views
        2. Oracle OLAP
        3. Star Transformation
        4. Encryption
      14. Summary
    3. 3 Exadata Software Features
      1. Smart Scan
        1. How Standard Queries Work
        2. How Smart Scan Queries Work
        3. Individual Tables
        4. Join Filtering
        5. Monitoring Savings from Smart Scan
      2. Other Offloaded Processing
        1. Fast File Creation
        2. Incremental Backup
        3. Data Mining Scoring
        4. Encryption
      3. Exadata Hybrid Columnar Compression
        1. What Is Exadata Hybrid Columnar Compression?
        2. How It Works
        3. Compression Options
        4. Decompression
        5. Advantages
        6. ILM and Oracle Compression
      4. Storage Indexes
        1. How Storage Indexes Work
        2. Storage Indexes at Work
      5. Exadata Smart Flash Cache
        1. What Is the Exadata Smart Flash Cache?
        2. How Can You Use the Exadata Smart Flash Cache?
        3. How Does Exadata Smart Flash Cache Determine What Is Cached?
        4. Exadata Smart Flash Cache Statistics
        5. Benefits from Exadata Smart Flash Cache
      6. I/O Resource Manager
        1. Benefits from I/O Resource Manager
        2. Architecture of an IORM Plan
        3. IORM at Work
      7. Interacting with Exadata Storage Server Software
        1. Management Software Components
        2. Command Interfaces
        3. CellCLI
        4. dcli
        5. ADRCI
        6. CellCLI Command Overview
      8. Summary
    4. 4 Oracle Exadata Database Machine Platform Hardware Components
      1. Latency and Balance
        1. Processor Speeds, Memory Capacity, and Storage
        2. How Hardware Components Work Together
        3. Oracle Exadata Database Machine Packaging Basics
        4. Installation and Initial Deployment Considerations
        5. Upgrade Choices for Existing Systems
        6. Connecting to the Database Machine
        7. Highly Available Hardware Considerations
      2. Summary
  11. PART II Best Practices
    1. 5 Managing the Exadata Database Machine
      1. Exadata Storage Server Architecture
        1. Database Server Software Components
        2. Exadata Storage Server Software Components
      2. Exadata Storage Server Administration
        1. Using CellCLI
        2. Exadata Storage Server OS Users and Privileges
        3. Using dcli
        4. Exadata Storage Server Setup
        5. Exadata Storage Server Security Configuration
      3. Exadata Storage Server Monitoring
        1. Monitoring with Metrics and Alerts
        2. Monitoring Active Requests
        3. Monitor Using the Oracle Database
        4. Monitoring with Oracle Enterprise Manager
        5. Oracle Integrated Lights Out Manager
      4. Summary
    2. 6 High Availability and Backup Strategies
      1. Exadata Maximum Availability Architecture (MAA)
        1. High Availability with Oracle Data Guard
        2. Using Oracle GoldenGate with Database Machine
        3. Database Machine Patches and Upgrades
        4. Exadata Storage Server High Availability
        5. Preventing Data Corruption
      2. Exadata Database Machine Backup and Recovery Best Practices
        1. Backup Tools Best Practices
        2. Oracle Database Backup Strategy
        3. Database Recovery Best Practices
      3. Summary
    3. 7 Deploying Data Warehouses on the Oracle Exadata Database Machine
      1. Data Warehousing Basics
      2. Generic Oracle Query Optimization
      3. Embedded Analytics in Oracle
        1. SQL Aggregation and Analytics Extensions
        2. OLAP
        3. Data Mining
      4. Unique Exadata Features for Optimal Query Response
      5. Data Warehousing Compression Techniques
      6. The Typical Life of a Query
      7. Best Practices for Data Loading
      8. Partitioning, Backups, and High Availability in Data Warehouses
      9. Data Models, Business Intelligence Tools, and Security
        1. Data Models
        2. Business Intelligence Tools
        3. Security Considerations
      10. Sizing the Platform for Data Warehousing and Justifying Purchase
      11. Summary
    4. 8 Exadata and OLTP
      1. OLTP Workloads and Exadata Features
      2. Exadata Hardware and OLTP
        1. General Hardware and Infrastructure Considerations
        2. Exadata Smart Flash Cache
      3. Oracle 11g and OLTP
        1. Classic Oracle Features
        2. Oracle and Linux
        3. Quality of Service Management
      4. Exadata Software and OLTP
      5. Exadata Nodes and OLTP
      6. Exadata as a Complete System
      7. Summary
    5. 9 Consolidating Databases with the Oracle Exadata Database Machine
      1. Why Consolidate?
      2. How the Oracle Exadata Database Machine Helps Consolidation
      3. Database Server Consolidation
        1. CPU Sizing Considerations
        2. Memory Sizing
        3. I/O Sizing
        4. System Sizing
        5. Storage Consolidation
        6. Network Consolidation
      4. Workload Consolidation and Isolation
        1. Services
        2. Database Server Pools
        3. Workload Management
      5. Meeting and Exceeding SLAs
        1. Instance Caging
        2. I/O Resource Manager (IORM)
        3. Quality of Service Management
      6. Consolidation Design
        1. RAC Considerations
        2. Workload-Based Consolidation
        3. Time Zone-Based Consolidation
        4. Overprovisioning Consolidation
        5. Tight SLA Provisioning
        6. Testing
      7. Summary
    6. 10 Migrating to the Exadata Database Machine
      1. Premigration Steps
        1. Discovering the Current Environment
        2. Database Machine Capacity Planning and Sizing
        3. Choosing a Migration Strategy
      2. Migration Steps for Non-Oracle Databases
        1. Database Schema Migration
        2. Server-side Scripts Migration
        3. Data Migration and Synchronization
        4. Using Automated Tools for Migration
      3. Migration Steps for Oracle Databases
        1. Migrating Using Physical Methods
        2. Migrating Using Logical Methods
      4. Summary
  12. A Exadata Capacity and Performance Specifications
    1. Exadata Database Machine Storage Capacity
    2. Exadata Storage Server Performance
  13. Index