This section describes how to generate replay compare period reports using the DBMS_WORKLOAD_REPLAY
package. This report only compares workload replays that contain at least 5 minutes of database time.
To generate replay compare period reports, use the DBMS_WORKLOAD_REPLAY
.COMPARE_PERIOD_REPORT
procedure:
BEGIN DBMS_WORKLOAD_REPLAY.COMPARE_PERIOD_REPORT ( replay_id1 => 12, replay_id2 => 17, format => DBMS_WORKLOAD_CAPTURE.TYPE_HTML, result => :report_bind); END; /
In this example, the COMPARE_PERIOD_REPORT
procedure generates a replay compare period report in HTML format that compares a workload replay with a replay ID of 12 with another replay with an ID of 17.
The COMPARE_PERIOD_REPORT
procedure in this example uses the following parameters:
The replay_id1
parameter specifies the numerical identifier of the workload replay after change for which the reported will be generated. This parameter is required.
The replay_id2
parameter specifies the numerical identifier of the workload replay before change for which the reported will be generated. If unspecified, the comparison will be performed with the workload capture.
The format
parameter specifies the report format. Valid values include DBMS_WORKLOAD_CAPTURE
.TYPE_HTML
for HTML and DBMS_WORKLOAD_CAPTURE
.TYPE_XML
for XML. This parameter is required.
The result parameter specifies the output of the report.
For information about how to interpret the replay compare period report, see "Reviewing Replay Compare Period Reports".
Oracle Database PL/SQL Packages and Types Reference for information about the DBMS_WORKLOAD_REPLAY
package