Reviewing Replay Compare Period Reports

You can use replay compare period reports to perform a high-level comparison of one workload replay to its capture or to another replay of the same capture. The replay compare period report contains a summary of the most important changes between the two runs. By reviewing this report, you can determine if any data divergence occurred and whether there were any significant performance changes. You can then use this information to determine the appropriate action to take, such as reviewing ADDM reports to diagnose a new concurrency issue, or running SQL Tuning Advisor to fix a new SQL performance problem.

The replay compare period report uses the following structure:

• General Information

  This section contains metadata about the two runs being compared in the report. Any init.ora parameter changes between the two runs are also shown here.

• Replay Divergence

  This section contains the divergence analysis of the second run relative to the first.

• Main Performance Statistics

  This section contains a high-level performance statistic comparison across the two runs (such as change in database time).

• Top SQL by Change in DB Time

  This section compares the performance change of top SQL statements (ordered by total changed in database time) from one run to the next.

• Hardware Usage Comparison

  This section compares the hardware resource usage across the two runs.

• ADDM Comparison

  This section contains an ADDM report comparison across the two runs.