Exporting AWR data enables detailed analysis of the workload. This data is also required if you plan to run the Replay Compare Period report or the AWR Compare Period report on a pair of workload captures or replays.
To export AWR data:
BEGIN DBMS_WORKLOAD_CAPTURE.EXPORT_AWR (capture_id => 2); END; /
In this example, the AWR snapshots that correspond to the workload capture with a capture ID of 2 are exported, along with any SQL tuning set that may have been captured during workload capture.
The EXPORT_AWR
procedure uses the capture_id
required parameter, which specifies the ID of the capture whose AWR snapshots will be exported. The value of the capture_id
parameter is displayed in the ID
column of the DBA_WORKLOAD_CAPTURES
view.
Oracle Database Reference for information about the DBA_WORKLOAD_CAPTURES
view