Oracle Database Real Application Testing User's Guide
Oracle Database Real Application Testing User's Guide
Introduction to Oracle Real Application Testing
“Introduction to Oracle Real Application Testing”
Database Replay
“Database Replay”
SQL Performance Analyzer
“SQL Performance Analyzer”
Introduction to Database Replay
“Introduction to Database Replay”
To analyze the effect of system changes using Database Replay:
“To analyze the effect of system changes using Database Replay:”
Workload Capture
“Workload Capture”
Workload Preprocessing
“Workload Preprocessing”
Workload Replay
“Workload Replay”
Analysis and Reporting
“Analysis and Reporting”
Capturing a Database Workload
“Capturing a Database Workload”
Prerequisites for Capturing a Database Workload
“Prerequisites for Capturing a Database Workload”
Workload Capture Options
“Workload Capture Options”
Restarting the Database
“Restarting the Database”
To restart all instances in a Oracle RAC configuration before workload capture:
“To restart all instances in a Oracle RAC configuration before workload capture:”
Using Filters with Workload Capture
“Using Filters with Workload Capture”
Setting Up the Capture Directory
“Setting Up the Capture Directory”
Workload Capture Restrictions
“Workload Capture Restrictions”
Capturing a Database Workload Using Enterprise Manager
“Capturing a Database Workload Using Enterprise Manager”
To capture a database workload using Enterprise Manager:
“To capture a database workload using Enterprise Manager:”
Monitoring Workload Capture Using Enterprise Manager
“Monitoring Workload Capture Using Enterprise Manager”
Monitoring an Active Workload Capture
“Monitoring an Active Workload Capture”
To monitor an active workload capture:
“To monitor an active workload capture:”
Stopping an Active Workload Capture
“Stopping an Active Workload Capture”
To stop an active workload capture:
“To stop an active workload capture:”
Managing a Completed Workload Capture
“Managing a Completed Workload Capture”
To manage a completed workload capture:
“To manage a completed workload capture:”
Preprocessing a Database Workload
“Preprocessing a Database Workload”
Preprocessing a Database Workload Using Enterprise Manager
“Preprocessing a Database Workload Using Enterprise Manager”
To preprocess a captured workload using Enterprise Manager:
“To preprocess a captured workload using Enterprise Manager:”
Replaying a Database Workload
“Replaying a Database Workload”
Setting Up the Test System
“Setting Up the Test System”
Restoring the Database
“Restoring the Database”
Resetting the System Time
“Resetting the System Time”
Steps for Replaying a Database Workload
“Steps for Replaying a Database Workload”
Setting Up the Replay Directory
“Setting Up the Replay Directory”
Resolving References to External Systems
“Resolving References to External Systems”
Remapping Connections
“Remapping Connections”
Specifying Replay Options
“Specifying Replay Options”
Preserving COMMIT Order
“Preserving COMMIT Order”
Controlling Session Logins
“Controlling Session Logins”
Controlling Think Time
“Controlling Think Time”
Using Filters with Workload Replay
“Using Filters with Workload Replay”
Setting Up Replay Clients
“Setting Up Replay Clients”
Calibrating Replay Clients
“Calibrating Replay Clients”
Starting Replay Clients
“Starting Replay Clients”
Displaying Host Information
“Displaying Host Information”
Replaying a Database Workload Using Enterprise Manager
“Replaying a Database Workload Using Enterprise Manager”
To replay a database workload using Enterprise Manager:
“To replay a database workload using Enterprise Manager:”
Monitoring Workload Replay Using Enterprise Manager
“Monitoring Workload Replay Using Enterprise Manager”
Monitoring an Active Workload Replay
“Monitoring an Active Workload Replay”
To monitor an active workload replay:
“To monitor an active workload replay:”
Viewing a Completed Workload Replay
“Viewing a Completed Workload Replay”
To view a completed workload replay:
“To view a completed workload replay:”
Analyzing Replayed Workload
“Analyzing Replayed Workload”
Using Workload Capture Reports
“Using Workload Capture Reports”
Generating Workload Capture Reports Using Enterprise Manager
“Generating Workload Capture Reports Using Enterprise Manager”
To generate a workload capture report using Enterprise Manager:
“To generate a workload capture report using Enterprise Manager:”
Reviewing Workload Capture Reports
“Reviewing Workload Capture Reports”
Using Workload Replay Reports
“Using Workload Replay Reports”
Generating Workload Replay Reports Using Enterprise Manager
“Generating Workload Replay Reports Using Enterprise Manager”
To generate a workload replay report using Enterprise Manager:
“To generate a workload replay report using Enterprise Manager:”
Reviewing Workload Replay Reports
“Reviewing Workload Replay Reports”
Using Replay Compare Period Reports
“Using Replay Compare Period Reports”
Generating Replay Compare Period Reports Using Enterprise Manager
“Generating Replay Compare Period Reports Using Enterprise Manager”
To generate a replay compare period report using Enterprise Manager:
“To generate a replay compare period report using Enterprise Manager:”
Introduction to SQL Performance Analyzer
“Introduction to SQL Performance Analyzer”
To analyze the SQL performance effect of system changes using SQL Performance Analyzer:
“To analyze the SQL performance effect of system changes using SQL Performance Analyzer:”
Capturing the SQL Workload
“Capturing the SQL Workload”
Setting Up the Test System
“Setting Up the Test System”
Creating a SQL Performance Analyzer Task
“Creating a SQL Performance Analyzer Task”
Measuring the Pre-Change SQL Performance
“Measuring the Pre-Change SQL Performance”
Making a System Change
“Making a System Change”
Measuring the Post-Change SQL Performance
“Measuring the Post-Change SQL Performance”
Comparing Performance Measurements
“Comparing Performance Measurements”
Fixing Regressed SQL Statements
“Fixing Regressed SQL Statements”
Creating an Analysis Task
“Creating an Analysis Task”
Creating an Analysis Task Using Enterprise Manager
“Creating an Analysis Task Using Enterprise Manager”
Using the Parameter Change Workflow
“Using the Parameter Change Workflow”
To use the SQL Performance Analyzer parameter change workflow:
“To use the SQL Performance Analyzer parameter change workflow:”
Using the Exadata Simulation Workflow
“Using the Exadata Simulation Workflow”
To use the SQL Performance Analyzer Exadata simulation workflow:
“To use the SQL Performance Analyzer Exadata simulation workflow:”
Using the Guided Workflow
“Using the Guided Workflow”
To use the SQL Performance Analyzer task guided workflow:
“To use the SQL Performance Analyzer task guided workflow:”
Creating a Pre-Change SQL Trial
“Creating a Pre-Change SQL Trial”
Creating a Pre-Change SQL Trial Using Enterprise Manager
“Creating a Pre-Change SQL Trial Using Enterprise Manager”
To create a pre-change SQL trial using Enterprise Manager:
“To create a pre-change SQL trial using Enterprise Manager:”
Creating a Post-Change SQL Trial
“Creating a Post-Change SQL Trial”
Creating a Post-Change SQL Trial Using Oracle Enterprise Manager
“Creating a Post-Change SQL Trial Using Oracle Enterprise Manager”
To create a post-change SQL trial using Enterprise Manager:
“To create a post-change SQL trial using Enterprise Manager:”
Comparing SQL Trials
“Comparing SQL Trials”
Comparing SQL Trials Using Oracle Enterprise Manager
“Comparing SQL Trials Using Oracle Enterprise Manager”
Analyzing SQL Performance Using Oracle Enterprise Manager
“Analyzing SQL Performance Using Oracle Enterprise Manager”
To analyze SQL performance using Enterprise Manager:
“To analyze SQL performance using Enterprise Manager:”
Reviewing the SQL Performance Analyzer Report Using Oracle Enterprise Manager
“Reviewing the SQL Performance Analyzer Report Using Oracle Enterprise Manager”
To generate and review the SQL Performance Analyzer report:
“To generate and review the SQL Performance Analyzer report:”
Reviewing the SQL Performance Analyzer Report: General Information
“Reviewing the SQL Performance Analyzer Report: General Information”
To review general information:
“To review general information:”
Reviewing the SQL Performance Analyzer Report: Global Statistics
“Reviewing the SQL Performance Analyzer Report: Global Statistics”
To review global statistics:
“To review global statistics:”
Reviewing the SQL Performance Analyzer Report: Global Statistics Details
“Reviewing the SQL Performance Analyzer Report: Global Statistics Details”
To review global statistics details:
“To review global statistics details:”
Tuning Regressed SQL Statements Using Oracle Enterprise Manager
“Tuning Regressed SQL Statements Using Oracle Enterprise Manager”
Creating SQL Plan Baselines
“Creating SQL Plan Baselines”
To create SQL plan baselines:
“To create SQL plan baselines:”
Running SQL Tuning Advisor
“Running SQL Tuning Advisor”
To run SQL Tuning Advisor:
“To run SQL Tuning Advisor:”
Testing a Database Upgrade
“Testing a Database Upgrade”
Upgrading from Oracle9i Database and Oracle Database 10g Release 1
“Upgrading from Oracle9i Database and Oracle Database 10g Release 1”
SQL Performance Analyzer Workflow for Database Upgrade from Oracle9i to Oracle Database 10g Release 2
“SQL Performance Analyzer Workflow for Database Upgrade from Oracle9i to Oracle Database 10g Release 2”
Enabling SQL Trace on the Production System
“Enabling SQL Trace on the Production System”
Creating a Mapping Table
“Creating a Mapping Table”
Building a SQL Tuning Set
“Building a SQL Tuning Set”
DBMS_SQLTUNE.SELECT_SQL_TRACE Function Parameters
“DBMS_SQLTUNE.SELECT_SQL_TRACE Function Parameters”
Running SQL Performance Analyzer to Test a Database Upgrade from Oracle9i Database and Oracle Database 10g Release 1
“Running SQL Performance Analyzer to Test a Database Upgrade from Oracle9i Database and Oracle Database 10g Release 1”
Testing a Database Upgrade from Oracle9i Database and Oracle Database 10g Release 1 Using Enterprise Manager
“Testing a Database Upgrade from Oracle9i Database and Oracle Database 10g Release 1 Using Enterprise Manager”
Upgrading from Oracle Database 10g Release 2 and Newer Releases
“Upgrading from Oracle Database 10g Release 2 and Newer Releases”
Running SQL Performance Analyzer to Test a Database Upgrade from Oracle Database 10g Release 2 and Newer Releases
“Running SQL Performance Analyzer to Test a Database Upgrade from Oracle Database 10g Release 2 and Newer Releases”
Testing a Database Upgrade from Oracle Database 10g Release 2 and Newer Releases Using Enterprise Manager
“Testing a Database Upgrade from Oracle Database 10g Release 2 and Newer Releases Using Enterprise Manager”
Tuning Regressed SQL Statements After Testing a Database Upgrade
“Tuning Regressed SQL Statements After Testing a Database Upgrade”