Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Oracle Real Application Testing

• 1.1 SQL Performance Analyzer
• 1.2 Database Replay

Part I SQL Performance Analyzer

2 Introduction to SQL Performance Analyzer

• 2.1 Capturing the SQL Workload
• 2.2 Setting Up the Test System
• 2.3 Creating a SQL Performance Analyzer Task
• 2.4 Measuring the Pre-Change SQL Performance
• 2.5 Making a System Change
• 2.6 Measuring the Post-Change SQL Performance
• 2.7 Comparing Performance Measurements
• 2.8 Fixing Regressed SQL Statements

3 Creating an Analysis Task

• 3.1 Creating an Analysis Task Using Enterprise Manager
  • 3.1.1 Using the Parameter Change Workflow
  • 3.1.2 Using the Optimizer Statistics Workflow
  • 3.1.3 Using the Exadata Simulation Workflow
  • 3.1.4 Using the Guided Workflow
• 3.2 Creating an Analysis Task Using APIs
  • 3.2.1 Running the Exadata Simulation Using APIs

4 Creating a Pre-Change SQL Trial

• 4.1 Creating a Pre-Change SQL Trial Using Enterprise Manager
• 4.2 Creating a Pre-Change SQL Trial Using APIs

5 Creating a Post-Change SQL Trial

• 5.1 Creating a Post-Change SQL Trial Using Oracle Enterprise Manager
• 5.2 Creating a Post-Change SQL Trial Using APIs

6 Comparing SQL Trials

• 6.1 Comparing SQL Trials Using Oracle Enterprise Manager
  • 6.1.1 Analyzing SQL Performance Using Oracle Enterprise Manager
  • 6.1.2 Reviewing the SQL Performance Analyzer Report Using Oracle Enterprise Manager
  • 6.1.3 Tuning Regressed SQL Statements Using Oracle Enterprise Manager
• 6.2 Comparing SQL Trials Using APIs
  • 6.2.1 Analyzing SQL Performance Using APIs
  • 6.2.2 Reviewing the SQL Performance Analyzer Report Using APIs
  • 6.2.3 Comparing SQL Tuning Sets Using APIs
  • 6.2.4 Tuning Regressed SQL Statements Using APIs
  • 6.2.5 Tuning Regressed SQL Statements From a Remote SQL Trial Using APIs
  • 6.2.6 Creating SQL Plan Baselines Using APIs
  • 6.2.7 Using SQL Performance Analyzer Views

7 Testing a Database Upgrade

• 7.1 Upgrading from Oracle9i Database and Oracle Database 10g Release 1
  • 7.1.1 Enabling SQL Trace on the Production System
  • 7.1.2 Creating a Mapping Table
  • 7.1.3 Building a SQL Tuning Set
  • 7.1.4 Testing Database Upgrades from Oracle9i Database and Oracle Database 10g Release 1
• 7.2 Upgrading from Oracle Database 10g Release 2 and Newer Releases
  • 7.2.1 Testing Database Upgrades from Oracle Database 10g Release 2 and Newer Releases
• 7.3 Tuning Regressed SQL Statements After Testing a Database Upgrade

Part II Database Replay

8 Introduction to Database Replay

• 8.1 Workload Capture
• 8.2 Workload Preprocessing
• 8.3 Workload Replay
• 8.4 Analysis and Reporting

9 Capturing a Database Workload

• 9.1 Prerequisites for Capturing a Database Workload
• 9.2 Workload Capture Options
  • 9.2.1 Restarting the Database
  • 9.2.2 Using Filters with Workload Capture
  • 9.2.3 Setting Up the Capture Directory
• 9.3 Workload Capture Restrictions
• 9.4 Enabling and Disabling the Workload Capture Feature
• 9.5 Capturing a Database Workload Using Enterprise Manager
• 9.6 Monitoring Workload Capture Using Enterprise Manager
  • 9.6.1 Monitoring an Active Workload Capture
  • 9.6.2 Stopping an Active Workload Capture
  • 9.6.3 Managing a Completed Workload Capture
• 9.7 Capturing a Database Workload Using APIs
  • 9.7.1 Defining Workload Capture Filters
  • 9.7.2 Starting a Workload Capture
  • 9.7.3 Stopping a Workload Capture
  • 9.7.4 Exporting AWR Data for Workload Capture
• 9.8 Monitoring Workload Capture Using Views

10 Preprocessing a Database Workload

• 10.1 Preprocessing a Database Workload Using Enterprise Manager
• 10.2 Preprocessing a Database Workload Using APIs
  • 10.2.1 Running the Workload Analyzer Command-Line Interface

11 Replaying a Database Workload

• 11.1 Setting Up the Test System
  • 11.1.1 Restoring the Database
  • 11.1.2 Resetting the System Time
• 11.2 Steps for Replaying a Database Workload
  • 11.2.1 Setting Up the Replay Directory
  • 11.2.2 Resolving References to External Systems
  • 11.2.3 Remapping Connections
  • 11.2.4 Specifying Replay Options
  • 11.2.5 Using Filters with Workload Replay
  • 11.2.6 Setting Up Replay Clients
• 11.3 Replaying a Database Workload Using Enterprise Manager
• 11.4 Monitoring Workload Replay Using Enterprise Manager
  • 11.4.1 Monitoring an Active Workload Replay
  • 11.4.2 Viewing a Completed Workload Replay
• 11.5 Replaying a Database Workload Using APIs
  • 11.5.1 Initializing Replay Data
  • 11.5.2 Connection Remapping
  • 11.5.3 Setting Workload Replay Options
  • 11.5.4 Defining Workload Replay Filters and Replay Filter Sets
  • 11.5.5 Setting the Replay Timeout Action
  • 11.5.6 Starting a Workload Replay
  • 11.5.7 Pausing a Workload Replay
  • 11.5.8 Resuming a Workload Replay
  • 11.5.9 Cancelling a Workload Replay
  • 11.5.10 Exporting AWR Data for Workload Replay
• 11.6 Monitoring Workload Replay Using APIs
  • 11.6.1 Retrieving Information About Diverged Calls
  • 11.6.2 Monitoring Workload Replay Using Views

12 Analyzing Replayed Workload

• 12.1 Using Workload Capture Reports
  • 12.1.1 Generating Workload Capture Reports Using Enterprise Manager
  • 12.1.2 Generating Workload Capture Reports Using APIs
  • 12.1.3 Reviewing Workload Capture Reports
• 12.2 Using Workload Replay Reports
  • 12.2.1 Generating Workload Replay Reports Using Enterprise Manager
  • 12.2.2 Generating Workload Replay Reports Using APIs
  • 12.2.3 Reviewing Workload Replay Reports
• 12.3 Using Compare Period Reports
  • 12.3.1 Generating Compare Period Reports Using Enterprise Manager
  • 12.3.2 Generating Compare Period Reports Using APIs
  • 12.3.3 Reviewing Replay Compare Period Reports

Index