You are previewing Oracle Exadata Recipes: A Problem-Solution Approach.
O'Reilly logo
Oracle Exadata Recipes: A Problem-Solution Approach

Book Description

Oracle Exadata Recipes takes an example-based, problem/solution approach in showing how to size, install, configure, manage, monitor, optimize, and migrate Oracle database workloads on and to the Oracle Exadata Database Machine. Whether you're an Oracle Database administrator, Unix/Linux administrator, storage administrator, network administrator, or Oracle developer, Oracle Exadata Recipes provides effective and proven solutions to accomplish a wide variety of tasks on the Exadata Database Machine. You can feel confident using the reliable solutions that are demonstrated in this book in your enterprise Exadata environment.

Managing Oracle Exadata is unlike managing a traditional Oracle database. Oracle's Exadata Database Machine is a pre-configured engineered system comprised of hardware and software, built to deliver extreme performance for Oracle Database workloads. Exadata delivers extreme performance by offering an optimally balanced hardware infrastructure with fast components at each layer of the engineered technology stack, as well as a unique set of Oracle software features designed to leverage the high-performing hardware infrastructure by reducing I/O demands. Let Oracle Exadata Recipes help you translate your existing Oracle Database knowledge into the exciting new growth area that is Oracle Exadata.

  • Helps extend your Oracle Database skillset to the fast-growing, Exadata platform

  • Presents information on managing Exadata in a helpful, example-based format

  • Clearly explains unique Exadata software and hardware features

What you'll learn

  • Install and configure Exadata

  • Manage your Exadata hardware infrastructure

  • Monitor and troubleshoot performance issues

  • Manage smart scan and cell offload processing

  • Take advantage of Hybrid Columnar Compression

  • Deploy Smart Flash Cache and Smart Flash Logging

  • Ensure the health of your Exadata environment

Who this book is for

Oracle Exadata Recipes is for Oracle Database administrators, Unix/Linux administrators, storage administrators, backup administrators, network administrators, and Oracle developers who want to quickly learn to develop effective and proven solutions without reading through a lengthy manual scrubbing for techniques. Readers in a hurry will appreciate the recipe format that sets up solutions to common tasks as the centerpiece of the book.

Table of Contents

  1. Title Page
  2. Dedication
  3. Contents at a Glance
  4. Contents
  5. About the Author
  6. About the Technical Reviewer
  7. Acknowledgments
  8. Introduction
  9. Part 1: Exadata Architecture
    1. Chapter 1: Exadata Hardware
      1. 1-1. Identifying Exadata Database Machine Components
      2. 1-2. Displaying Storage Server Architecture Details
      3. 1-3. Displaying Compute Server Architecture Details
      4. 1-4. Listing Disk Storage Details on the Exadata Storage Servers
      5. 1-5. Listing Disk Storage Details on the Compute Servers
      6. 1-6. Listing Flash Storage on the Exadata Storage Servers
      7. 1-7. Gathering Configuration Information for the InfiniBandSwitches
    2. Chapter 2: Exadata Software
      1. 2-1. Understanding the Role of Exadata Storage Server Software
      2. 2-2. Validating Oracle 11gR2 Databases on Exadata
      3. 2-3. Validating Oracle 11gR2 Grid Infrastructure on Exadata
      4. 2-4. Locating the Oracle Cluster Registry and Voting Disks on Exadata
      5. 2-5. Validating Oracle 11gR2 Real Application Clusters Installation and Database Storage on Exadata
      6. 2-6. Validating Oracle 11gR2 Real Application Clusters Networking on Exadata
    3. Chapter 3: How Oracle Works on Exadata
      1. 3-1. Mapping Physical Disks, LUNs, and Cell Disks on the Storage Servers
      2. 3-2. Mapping ASM Disks, Grid Disks, and Cell Disks
      3. 3-3. Mapping Flash Disks to Smart Flash Storage
      4. 3-4. Identifying Cell Server Software Processes
      5. 3-5. Tracing Oracle I/O Requests on Exadata Compute Nodes
      6. 3-6. Validating That Your Oracle RAC Interconnect Is Using InfiniBand
      7. 3-7. Tracing cellsrv on the Storage Servers
  10. Part 2: Preparing for Exadata
    1. Chapter 4: Workload Qualification
      1. 4-1. Quantifying I/O Characteristics of Your Current Database
      2. 4-2. Conducting a Smart Scan Fit Analysis Using AWR
      3. 4-3. Conducting a Smart Scan Fit Analysis Using Exadata Simulation
      4. 4-4. Performing a Hybrid Columnar Compression Fit Assessment
    2. Chapter 5: Sizing Exadata
      1. 5-1. Determining CPU Requirements
      2. 5-2. Determining IOPs Requirements
      3. 5-3. Determining I/O Bandwidth Requirements
      4. 5-4. Determining ASM Redundancy Requirements
      5. 5-5. Forecasting Storage Capacity
      6. 5-6. Planning for Database Growth
      7. 5-7. Planning for Disaster Recovery
      8. 5-8. Planning for Backups
      9. 5-9. Determining Your Fast Recovery Area and RECO Disk Group Size Requirements
    3. Chapter 6: Preparing for Exadata
      1. 6-1. Planning and Understanding Exadata Networking
      2. 6-2. Configuring DNS
      3. 6-3. Running checkip.sh
      4. 6-4. Customizing Your InfiniBand Network Configuration
      5. 6-5. Determining Your DATA and RECO Storage Requirements
      6. 6-6. Planning for ASM Disk Group Redundancy
      7. 6-7. Planning Database and ASM Extent Sizes
      8. 6-8. Completing the Pre-Delivery Survey
      9. 6-9. Completing the Configuration Worksheet
  11. Part 3: Exadata Administration
    1. Chapter 7: Administration and Diagnostics Utilities
      1. 7-1. Logging in to the Exadata Compute and Storage Cells Using SSH
      2. 7-2. Configuring SSH Equivalency
      3. 7-3. Locating Key Configuration Files and Directories on the Cell Servers
      4. 7-4. Locating Key Configuration Files and Directories on the Compute Nodes
      5. 7-5. Starting and Stopping Cell Server Processes
      6. 7-6. Administering Storage Cells Using CellCLI
      7. 7-7. Administering Storage Cells Using dcli
      8. 7-8. Generating Diagnostics from the ILOM Interface
      9. 7-9. Performing an Exadata Health Check Using exachk
      10. 7-10. Collecting Compute and Cell Server Diagnostics Using the sundiag.sh Utility
      11. 7-11. Collecting RAID Storage Information Using the MegaCLI utility
      12. 7-12. Administering the Storage Cell Network Using ipconf
      13. 7-13. Validating Your InfiniBand Switches with the CheckSWProfile.sh Utility
      14. 7-14. Verifying Your InfiniBand Network Topology
      15. 7-15. Diagnosing Your InfiniBand Network
      16. 7-16. Connecting to Your Cisco Catalyst 4948 Switch and Changing Switch Configuration
    2. Chapter 8: Backup and Recovery
      1. 8-1. Backing Up the Storage Servers
      2. 8-2. Displaying the Contents of Your CELLBOOT USB Flash Drive
      3. 8-3. Creating a Cell Boot Image on an External USB Drive
      4. 8-4. Backing Up Your Compute Nodes Using Your Enterprise Backup Software
      5. 8-5. Backing Up the Compute Servers Using LVM Snapshots
      6. 8-6. Backing Up Your Oracle Databases with RMAN
      7. 8-7. Backing Up the InfiniBand Switches
      8. 8-8. Recovering Storage Cells from Loss of a Single Disk
      9. 8-9. Recovering Storage Cells from Loss of a System Volume Using CELLBOOT Rescue
      10. 8-10. Recovering from a Failed Storage Server Patch
      11. 8-11. Recovering Compute Server Using LVM Snapshots
      12. 8-12. Reimaging a Compute Node
      13. 8-13. Recovering Your InfiniBand Switch Configuration
      14. 8-14. Recovering from Loss of Your Oracle Cluster Registry and Voting Disks
    3. Chapter 9: Storage Administration
      1. 9-1. Building ASM Disk Groups on Exadata
      2. 9-2. Properly Configuring ASM Disk Group Attributes on Exadata
      3. 9-3. Identifying Unassigned Grid Disks
      4. 9-4. Configuring ASM Redundancy on Exadata
      5. 9-5. Displaying ASM Partner Disk Relationships on Exadata
      6. 9-6. Measuring ASM Extent Balance on Exadata
      7. 9-7. Rebuilding Cell Disks
      8. 9-8. Creating Interleaved Cell Disks and Grid Disks
      9. 9-9. Rebuilding Grid Disks
      10. 9-10. Setting smart_scan_capable on ASM Disk Groups
      11. 9-11. Creating Flash Grid Disks for Permanent Storage
    4. Chapter 10: Network Administration
      1. 10-1. Configuring the Management Network on the Compute Nodes
      2. 10-2. Configuring the Client Access Network
      3. 10-3. Configuring the Private Interconnect on the Compute Nodes
      4. 10-4. Configuring the SCAN Listener
      5. 10-5. Managing Grid Infrastructure Network Resources
      6. 10-6. Configuring the Storage Server Ethernet Network
      7. 10-7. Changing IP Addresses on Your Exadata Database Machine
    5. Chapter 11: Patching and Upgrades
      1. 11-1. Understanding Exadata Patching Definitions, Alternatives, and Strategies
      2. 11-2. Preparing to Apply Exadata Patches
      3. 11-3. Patching Your Exadata Storage Servers
      4. 11-4. Patching Your Exadata Compute Nodes and Databases
      5. 11-5. Patching the InfiniBand Switches
      6. 11-6. Patching Your Enterprise Manager Systems Management Software
    6. Chapter 12: Security
      1. 12-1. Configuring Multiple Oracle Software Owners on Exadata Compute Nodes
      2. 12-2. Installing Multiple Oracle Homes on Your Exadata Compute Nodes
      3. 12-3. Configuring ASM-Scoped Security
      4. 12-4. Configuring Database-Scoped Security
  12. Part 4: Monitoring Exadata
    1. Chapter 13: Monitoring Exadata Storage Cells
      1. 13-1. Monitoring Storage Cell Alerts
      2. 13-2. Monitoring Cells with Active Requests
      3. 13-3. Monitoring Cells with Metrics
      4. 13-4. Configuring Thresholds for Cell Metrics
      5. 13-5. Using dcli with Special Characters
      6. 13-6. Reporting and Summarizing metrichistory Using R
      7. 13-7. Reporting and Summarizing metrichistory Using Oracle and SQL
      8. 13-8. Detecting Cell Disk I/O Bottlenecks
      9. 13-9. Measuring Small I/O vs. Large I/O Requests
      10. 13-10. Detecting Grid Disk I/O Bottlenecks
      11. 13-11. Detecting Host Interconnect Bottlenecks
      12. 13-12. Measuring I/O Load and Waits per Database, Resource Consumer Group, and Resource Category
    2. Chapter 14: Host and Database Performance Monitoring
      1. 14-1. Collecting Historical Compute Node and Storage Cell Host Performance Statistics
      2. 14-2. Displaying Real-Time Compute Node and Storage Cell Performance Statistics
      3. 14-3. Monitoring Exadata with Enterprise Manager
      4. 14-4. Monitoring Performance with SQL Monitoring
      5. 14-5. Monitoring Performance by Database Time
      6. 14-6. Monitoring Smart Scans by Database Time and AAS
      7. 14-7. Monitoring Exadata with Wait Events
      8. 14-8. Monitoring Exadata with Statistics and Counters
      9. 14-9. Measuring Cell I/O Statistics for a SQL Statement
  13. Part 5: Exadata Software
    1. Chapter 15: Smart Scan and Cell Offload
      1. 15-1. Identifying Cell Offload in Execution Plans
      2. 15-2. Controlling Cell Offload Behavior
      3. 15-3. Measuring Smart Scan with Statistics
      4. 15-4. Measuring Offload Statistics for Individual SQL Cursors
      5. 15-5. Measuring Offload Efficiency
      6. 15-6. Identifying Smart Scan from 10046 Trace Files
      7. 15-7. Qualifying for Direct Path Reads
      8. 15-8. Influencing Exadata’s Decision to Use Smart Scans
      9. 15-9. Identifying Partial Cell Offload
      10. 15-10. Dealing with Fast Object Checkpoints
    2. Chapter 16: Hybrid Columnar Compression
      1. 16-1. Estimating Disk Space Savings for HCC
      2. 16-2. Building HCC Tables and Partitions
      3. 16-3. Contrasting Oracle Compression Types
      4. 16-4. Determining the Compression Type of a Segment
      5. 16-5. Measuring the Performance Impact of HCC for Queries
      6. 16-6. Direct Path Inserts into HCC Segments
      7. 16-7. Conventional Inserts to HCC Segments
      8. 16-8. DML and HCC
      9. 16-9. Decompression and the Performance Impact
    3. Chapter 17: I/O Resource Management and Instance Caging
      1. 17-1. Prioritizing I/O Utilization by Database
      2. 17-2. Limiting I/O Utilization for Your Databases
      3. 17-3. Managing Resources within a Database
      4. 17-4. Prioritizing I/O Utilization by Category of Resource Consumers
      5. 17-5. Prioritizing I/O Utilization by Categories of Resource Consumers and Databases
      6. 17-6. Monitoring Performance When IORM Is Enabled
      7. 17-7. Obtaining IORM Plan Information
      8. 17-8. Controlling Smart Flash Cache and Smart Flash Logging with IORM
      9. 17-9. Limiting CPU Resources with Instance Caging
    4. Chapter 18: Smart Flash Cache and Smart Flash Logging
      1. 18-1. Managing Smart Flash Cache and Smart Flash Logging
      2. 18-2. Determining Which Database Objects Are Cached
      3. 18-3. Determining What’s Consuming Your Flash Cache Storage
      4. 18-4. Determining What Happens When Querying Uncached Data
      5. 18-5. Measuring Smart Flash Cache Performance
      6. 18-6. Pinning Specific Objects in Smart Flash Cache
      7. 18-7. Quantifying Benefits of Smart Flash Logging
    5. Chapter 19: Storage Indexes
      1. 19-1. Measuring Performance Impact of Storage Indexes
      2. 19-2. Measuring Storage Index Performance with Not-So-Well-Ordered Data
      3. 19-3. Testing Storage Index Behavior with Different Query Predicate Conditions
      4. 19-4. Tracing Storage Index Behavior
      5. 19-5. Tracing Storage Indexes When More than Eight Columns Are Referenced
      6. 19-6. Tracing Storage Indexes when DML Is Issued against Tables
      7. 19-7. Disabling Storage Indexes
      8. 19-8. Troubleshooting Storage Indexes
  14. Part 6: Post Implementation Tasks
    1. Chapter 20: Post-Installation Monitoring Tasks
      1. 20-1. Installing Enterprise Manager 12c Cloud Control Agents for Exadata
      2. 20-2. Configuring Enterprise Manager 12c Cloud Control Plug-ins for Exadata
      3. 20-3. Configuring Automated Service Requests
    2. Chapter 21: Post-Install Database Tasks
      1. 21-1. Creating a New Oracle RAC Database on Exadata
      2. 21-2. Setting Up a DBFS File System on Exadata
      3. 21-3. Configuring HugePages on Exadata
      4. 21-4. Configuring Automatic Degree of Parallelism
      5. 21-5. Setting I/O Calibration on Exadata
      6. 21-6. Measuring Impact of Auto DOP and Parallel Statement Queuing
      7. 21-7. Measuring Auto DOP and In-Memory Parallel Execution
      8. 21-8. Gathering Optimizer Statistics on Exadata
  15. Index