Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Oracle Real Application Testing

• 1.1 Database Replay
• 1.2 SQL Performance Analyzer

Part I Database Replay

2 Introduction to Database Replay

• 2.1 Workload Capture
• 2.2 Workload Preprocessing
• 2.3 Workload Replay
• 2.4 Analysis and Reporting

3 Capturing a Database Workload

• 3.1 Prerequisites for Capturing a Database Workload
• 3.2 Workload Capture Options
  • 3.2.1 Restarting the Database
  • 3.2.2 Using Filters with Workload Capture
  • 3.2.3 Setting Up the Capture Directory
• 3.3 Workload Capture Restrictions
• 3.4 Enabling and Disabling the Workload Capture Feature
• 3.5 Capturing a Database Workload Using Enterprise Manager
• 3.6 Monitoring Workload Capture Using Enterprise Manager
  • 3.6.1 Monitoring an Active Workload Capture
  • 3.6.2 Stopping an Active Workload Capture
  • 3.6.3 Managing a Completed Workload Capture
• 3.7 Capturing a Database Workload Using APIs
  • 3.7.1 Defining Workload Capture Filters
  • 3.7.2 Starting a Workload Capture
  • 3.7.3 Stopping a Workload Capture
  • 3.7.4 Exporting AWR Data for Workload Capture
• 3.8 Monitoring Workload Capture Using Views

4 Preprocessing a Database Workload

• 4.1 Preprocessing a Database Workload Using Enterprise Manager
• 4.2 Preprocessing a Database Workload Using APIs

5 Replaying a Database Workload

• 5.1 Setting Up the Test System
  • 5.1.1 Restoring the Database
  • 5.1.2 Resetting the System Time
• 5.2 Steps for Replaying a Database Workload
  • 5.2.1 Setting Up the Replay Directory
  • 5.2.2 Resolving References to External Systems
  • 5.2.3 Remapping Connections
  • 5.2.4 Specifying Replay Options
  • 5.2.5 Using Filters with Workload Replay
  • 5.2.6 Setting Up Replay Clients
• 5.3 Replaying a Database Workload Using Enterprise Manager
• 5.4 Monitoring Workload Replay Using Enterprise Manager
  • 5.4.1 Monitoring an Active Workload Replay
  • 5.4.2 Viewing a Completed Workload Replay
• 5.5 Replaying a Database Workload Using APIs
  • 5.5.1 Initializing Replay Data
  • 5.5.2 Connection Remapping
  • 5.5.3 Setting Workload Replay Options
  • 5.5.4 Defining Workload Replay Filters and Replay Filter Sets
  • 5.5.5 Starting a Workload Replay
  • 5.5.6 Pausing a Workload Replay
  • 5.5.7 Resuming a Workload Replay
  • 5.5.8 Cancelling a Workload Replay
  • 5.5.9 Exporting AWR Data for Workload Replay
• 5.6 Monitoring Workload Replay Using APIs
  • 5.6.1 Retrieving Information About Diverged Calls
  • 5.6.2 Monitoring Workload Replay Using Views

6 Analyzing Replayed Workload

• 6.1 Using Workload Capture Reports
  • 6.1.1 Generating Workload Capture Reports Using Enterprise Manager
  • 6.1.2 Generating Workload Capture Reports Using APIs
  • 6.1.3 Reviewing Workload Capture Reports
• 6.2 Using Workload Replay Reports
  • 6.2.1 Generating Workload Replay Reports Using Enterprise Manager
  • 6.2.2 Generating Workload Replay Reports Using APIs
  • 6.2.3 Reviewing Workload Replay Reports
• 6.3 Using Replay Compare Period Reports
  • 6.3.1 Generating Replay Compare Period Reports Using Enterprise Manager
  • 6.3.2 Generating Replay Compare Period Reports Using APIs
  • 6.3.3 Reviewing Replay Compare Period Reports
• 6.4 Using SQL Performance Analyzer to Compare SQL Tuning Sets

Part II SQL Performance Analyzer

7 Introduction to SQL Performance Analyzer

• 7.1 Capturing the SQL Workload
• 7.2 Setting Up the Test System
• 7.3 Creating a SQL Performance Analyzer Task
• 7.4 Measuring the Pre-Change SQL Performance
• 7.5 Making a System Change
• 7.6 Measuring the Post-Change SQL Performance
• 7.7 Comparing Performance Measurements
• 7.8 Fixing Regressed SQL Statements

8 Creating an Analysis Task

• 8.1 Creating an Analysis Task Using Enterprise Manager
  • 8.1.1 Using the Parameter Change Workflow
  • 8.1.2 Using the Exadata Simulation Workflow
  • 8.1.3 Using the Guided Workflow
• 8.2 Creating an Analysis Task Using APIs
  • 8.2.1 Running the Exadata Simulation Using APIs

9 Creating a Pre-Change SQL Trial

• 9.1 Creating a Pre-Change SQL Trial Using Enterprise Manager
• 9.2 Creating a Pre-Change SQL Trial Using APIs

10 Creating a Post-Change SQL Trial

• 10.1 Creating a Post-Change SQL Trial Using Oracle Enterprise Manager
• 10.2 Creating a Post-Change SQL Trial Using APIs

11 Comparing SQL Trials

• 11.1 Comparing SQL Trials Using Oracle Enterprise Manager
  • 11.1.1 Analyzing SQL Performance Using Oracle Enterprise Manager
  • 11.1.2 Reviewing the SQL Performance Analyzer Report Using Oracle Enterprise Manager
  • 11.1.3 Tuning Regressed SQL Statements Using Oracle Enterprise Manager
• 11.2 Comparing SQL Trials Using APIs
  • 11.2.1 Analyzing SQL Performance Using APIs
  • 11.2.2 Reviewing the SQL Performance Analyzer Report Using APIs
  • 11.2.3 Comparing SQL Tuning Sets Using APIs
  • 11.2.4 Tuning Regressed SQL Statements Using APIs
  • 11.2.5 Tuning Regressed SQL Statements From a Remote SQL Trial Using APIs
  • 11.2.6 Creating SQL Plan Baselines Using APIs
  • 11.2.7 Using SQL Performance Analyzer Views

12 Testing a Database Upgrade

• 12.1 Upgrading from Oracle9i Database and Oracle Database 10g Release 1
  • 12.1.1 Enabling SQL Trace on the Production System
  • 12.1.2 Creating a Mapping Table
  • 12.1.3 Building a SQL Tuning Set
  • 12.1.4 Running SQL Performance Analyzer to Test a Database Upgrade from Oracle9i Database and Oracle Database 10g Release 1
• 12.2 Upgrading from Oracle Database 10g Release 2 and Newer Releases
  • 12.2.1 Running SQL Performance Analyzer to Test a Database Upgrade from Oracle Database 10g Release 2 and Newer Releases
• 12.3 Tuning Regressed SQL Statements After Testing a Database Upgrade

Index