Viewing a Completed Workload Replay

This section describes how to view a completed workload replay using Enterprise Manager.

To view a completed workload replay:

1. On the Software and Support page, under Real Application Testing, click Database Replay.

   The Database Replay page appears.

2. In the Go to Task column, click the icon that corresponds to the Replay Workload task.

   The Replay Workload page appears.

3. In the Directory Object list, select the directory that contains the replayed workload that you want to view.

   After the directory is selected, the Replay Workload page will be refreshed to display the Capture Summary and the Replay History sections.

4. The Replay History section displays previous replays of the workload capture. To view details about a replay, select the replay and click View.

   The View Workload Replay page appears.

5. Under Summary, information about the workload replay is displayed.

6. To view the workload profile, click the Workload Profile tab.

   There are two types of charts that are available under the Workload Profile tab:

   • Elapsed Time Comparison

     To view this chart, in the Chart Type field, select Elapsed Time Comparison.

     The Elapsed Time Comparison chart shows how much time it has taken to replay the same workload compared to the elapsed time during the workload capture. If the Replay bar is shorter than the Capture bar, the replay system is processing the workload faster than the capture system.

   • User Call Progress

     To view this chart, in the Chart Type field, select User Call Progress.

     The User Call Progress chart shows how much time it has taken to replay the same workload compared to the elapsed time during the workload capture in terms of user calls. If the Replay line is above or to the left of the Capture line, the replay system is processing the workload faster than the capture system.

   Under Divergence, any error and data discrepancies between the replay system and the capture system are displayed. This information can be used as a measure of the replay quality.

   To view a detailed comparison of the workload during capture and replay, expand Detailed Comparison.

   The Detailed Comparison section displays the following information:

   • Duration

     The duration that was captured in a workload is compared to the amount of time it took to replay the workload. In the Capture column, the duration of the time period that was captured is shown. In the Replay column, the amount of time it took to replay the workload is shown. The Percentage of Capture column shows the percentage of the captured duration that it took to replay the workload. If the value is under 100 percent, the replay system processed the workload faster than the capture system. If the value is over 100 percent, the replay system processed the workload slower than the capture system.

   • Database time

     The database time that is consumed in the time period that was captured is compared to the amount of database time that is consumed when replaying the workload.

   • Average active sessions

     The number of average active sessions captured in the workload is compared to the number of average active session that are replayed.

   • User calls

     The number of user calls captured in the workload is compared to the number of user calls that are replayed.

   To view the workload replay report, click View Workload Replay Report. For information about using the Workload Replay report, see "Reviewing Workload Replay Reports".

7. To view the connection strings used in the capture and the replay systems, click the Connection Mappings tab.

8. To view replay parameters used by the workload replay, click the Replay Parameters tab.

9. To run a report, click the Report tab.

   There are several types of reports you can run for a completed workload replay:

   • Workload Replay

     The Workload Replay report contains information that can be used to measure data and performance divergence between the capture system and the replay system. To run this report, under Workload Replay Report, click Run Report. For information about using the Workload Replay report, see "Reviewing Workload Replay Reports".

   • Replay Compare Period

     The Replay Compare Period report can be used to compare one workload replay to its capture or to another replay of the same capture. To run this report, under Compare Period Report, select the first and second workload captures or replays you want to compare and click Run Replay Compare Period Report.

   • AWR Compare Period

     The AWR Compare Period report can be used to compare the AWR data in one workload capture or replay with another. Before running this report, AWR data for the captured or replayed workload must have been previously exported. To run this report, under Compare Period Report, select the first and second workload captures or replays you want to compare and click Run AWR Compare Period Report. If AWR data is not previously exported from the captured or replayed workload, you will be prompted to import the AWR data before continuing. For more information about the AWR Compare Period report, see Using the AWR Compare Periods Reports.

   • AWR

     The AWR report shows the AWR data contained in a workload that was captured or replayed. Before running this report, AWR data must have been previously exported from the captured or replayed workload. To run this report, under AWR Report, select the workload capture or replay for which you want to generate an AWR report and click Run Report. If AWR data is not previously exported from the captured or replayed workload, you will be prompted to import the AWR data before continuing. For more information about the AWR report, see Oracle Database Performance Tuning Guide.

   • ASH

     The ASH report contains active session history (ASH) information for a specified duration of a workload that was captured or replayed. Before running this report, AWR data must have been previously exported from the captured or replayed workload. To run this report, under ASH Report, select the workload capture or replay for which you want to generate an ASH report. Specify the duration using the Start Date, Start Time, End Date, and End Time fields. You can also apply filters using the Filter field. Once the duration and filters are specified, click Run Report. If AWR data is not previously exported from the captured or replayed workload, you will be prompted to import the AWR data before continuing. For more information about the ASH report, see Active Session History Reports.

   The Report window opens while the report is being generated. Once the report is generated, you can save the report by clicking Save to File.

10. To return to the Database Replay page, click OK.