Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Oracle Real Application Testing

• Database Replay
• SQL Performance Analyzer

Part I Database Replay

2 Introduction to Database Replay

• Workload Capture
• Workload Preprocessing
• Workload Replay
• Analysis and Reporting

3 Capturing a Database Workload

• Prerequisites for Capturing a Database Workload
• Workload Capture Options
  • Restarting the Database
  • Defining the Workload Filters
  • Setting Up the Capture Directory
• Workload Capture Restrictions
• Enabling and Disabling the Workload Capture Feature
• Capturing a Database Workload Using Enterprise Manager
• Monitoring Workload Capture Using Enterprise Manager
  • Monitoring an Active Workload Capture
  • Stopping an Active Workload Capture
  • Managing a Completed Workload Capture
• Capturing a Database Workload Using APIs
  • Adding and Removing Workload Filters
  • Starting a Workload Capture
  • Stopping a Workload Capture
  • Exporting AWR Data for Workload Capture
• Monitoring Workload Capture Using Views

4 Preprocessing a Database Workload

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

5 Replaying a Database Workload

• Setting Up the Test System
  • Restoring the Database
  • Resetting the System Time
• Steps for Replaying a Database Workload
  • Setting Up the Replay Directory
  • Resolving References to External Systems
  • Remapping Connections
  • Specifying Replay Options
    • Preserving COMMIT Order
    • Controlling Session Logins
    • Controlling Think Time
  • Setting Up Replay Clients
    • Calibrating Replay Clients
    • Starting Replay Clients
    • Displaying Host Information
• Replaying a Database Workload Using Enterprise Manager
• Monitoring Workload Replay Using Enterprise Manager
  • Monitoring an Active Workload Replay
  • Viewing a Completed Workload Replay
• Replaying a Database Workload Using APIs
  • Initializing Replay Data
  • Connection Remapping
  • Setting Workload Replay Options
  • Starting a Workload Replay
  • Stopping a Workload Replay
  • Exporting AWR Data for Workload Replay
• Monitoring Workload Replay Using Views

6 Analyzing Replayed Workload

• Generating a Workload Capture Report Using Enterprise Manager
• Generating a Workload Capture Report Using APIs
• Using a Workload Capture Report
• Generating a Workload Replay Report Using Enterprise Manager
• Generating a Workload Replay Report Using APIs
• Using a Workload Replay Report

Part II SQL Performance Analyzer

7 Introduction to SQL Performance Analyzer

• Capturing the SQL Workload
• Setting Up the Test System
• Creating a SQL Performance Analyzer Task
• Measuring the Pre-Change SQL Performance
• Making a System Change
• Measuring the Post-Change SQL Performance
• Comparing Performance Measurements
• Fixing Regressed SQL Statements

8 Creating an Analysis Task

• Creating an Analysis Task Using Enterprise Manager
  • Using the Parameter Change Workflow
  • Using the Guided Workflow
• Creating an Analysis Task Using APIs

9 Creating a Pre-Change SQL Trial

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

10 Creating a Post-Change SQL Trial

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

11 Comparing SQL Trials

• Comparing SQL Trials Using Oracle Enterprise Manager
  • Analyzing SQL Performance Using Oracle Enterprise Manager
  • Reviewing the SQL Performance Analyzer Report Using Oracle Enterprise Manager
    • Reviewing the SQL Performance Analyzer Report: General Information
    • Reviewing the SQL Performance Analyzer Report: Global Statistics
    • Reviewing the SQL Performance Analyzer Report: Global Statistics Details
  • Tuning Regressed SQL Statements Using Oracle Enterprise Manager
    • Creating SQL Plan Baselines
    • Running SQL Tuning Advisor
• Comparing SQL Trials Using APIs
  • Analyzing SQL Performance Using APIs
  • Reviewing the SQL Performance Analyzer Report Using APIs
    • General Information
    • Result Summary
      • Overall Performance Statistics
      • Performance Statistics of SQL Statements
      • Errors
    • Result Details
      • SQL Details
      • Single Execution Statistics
      • Execution Plans
  • Tuning Regressed SQL Statements Using APIs
  • Using SQL Performance Analyzer Views

12 Testing a Database Upgrade

• Upgrading from Oracle Database 10g Release 1 and Older Releases
  • Enabling SQL Trace on the Production System
  • Creating a Mapping Table
  • Building a SQL Tuning Set
  • Building the Pre-Upgrade SQL Trial for Oracle 10g Release 1 and Older Releases
    • Building the Pre-Upgrade SQL Trial for Oracle 10g Release 1 and Older Releases Using Enterprise Manager
    • Building the Pre-Upgrade SQL Trial for Oracle 10g Release 1 and Older Releases Using APIs
  • Building the Post-Upgrade SQL Trial Upgrading from Oracle Database 10g Release 1 and Older Releases
    • Building the Post-Upgrade SQL Trial Upgrading from Oracle Database 10g Release 1 and Older Releases Using Enterprise Manager
    • Building the Post-Upgrade SQL Trial Upgrading from Oracle Database 10g Release 1 and Older Releases Using APIs
• Upgrading from Oracle Database 10g Release 2 and Newer Releases
  • Building the Pre-Upgrade SQL Trial for Oracle Database 10g Release 2 and Newer Releases
    • Building the Pre-Upgrade SQL Trial for Oracle Database 10g Release 2 and Newer Releases Using Enterprise Manager
    • Building the Pre-Upgrade SQL Trial for Oracle Database 10g Release 2 and Newer Releases Using APIs
  • Building the Post-Upgrade SQL Trial Upgrading from Oracle Database 10g Release 2 and Newer Releases
    • Building the Post-Upgrade SQL Trial Upgrading from Oracle Database 10g Release 2 and Newer Releases Using Enterprise Manager
    • Building the Post-Upgrade SQL Trial Upgrading from Oracle Database 10g Release 2 and Newer Releases Using APIs
• Tuning Regressed SQL Statements After Testing a Database Upgrade

Index