SQL Performance Analyzer

Real Application Testing is used to test the impact of any change e.g upgrade, on the database. It has two components:

 1. Database Replay
 2. SQL Performance Analyzer

Database Replay is a tool for capturing the real workload in database and play it at will. But it captures the entire workload of the database.
SQL performance Analyzer is used to know the impact of any change e.g parameter change, on one or more SQLs.

Steps to use SQLPA:

1. Create SQLSET using DBMS_SQLTUNE.CREATE_SQLSET

2. Load SQLSET ( from Cursors,awr or sql traces) using DBMS_SQLTUNE.LOAD_SQLSET

3. Create SQLPA analysis task using DBMS_SQLPA.CREATE_ANALYSIS_TASK

4. Execute analysis task using DBMS_SQLPA.EXECUTE_ANALYSIS_TASK

5. Report analysis task using DBMS_SQLPA.REPORT_ANALYSIS_TASK