Contents

List of Figures

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Database Replay

• Overview of Database Replay
  • Workload Capture
  • Workload Preprocessing
  • Workload Replay
  • Analysis and Reporting
• Capturing a Database Workload
  • Enabling and Disabling Workload Capture
  • Prerequisites for Capturing a Database Workload
  • Workload Capture Options
    • Restarting the Database
    • Defining the Workload Filters
    • Setting Up the Capture Directory
  • Workload Capture Restrictions
  • 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
• Analyzing Workload Capture
  • Generating a Workload Capture Report Using Enterprise Manager
  • Generating a Workload Capture Report Using APIs
  • Using a Workload Capture Report

2 SQL Performance Analyzer

• Overview of SQL Performance Analyzer
• Capturing a SQL Workload
  • Capturing a SQL Workload Using the Enterprise Manager
  • Capturing a SQL Workload Using APIs
• Transporting a SQL Workload
  • Exporting a SQL Workload Using Enterprise Manager
  • Transporting a SQL Workload Using APIs