Importing AWR Data for Workload Replay

After AWR data is exported from the replay system, you can import the AWR data into another system. Importing AWR data enables detailed analysis of the workload. This data is also required if you plan to run the AWR Compare Period report on a pair of workload captures or replays.

To import AWR data:

• Use the IMPORT_AWR function:

  CREATE USER capture_awr
  SELECT DBMS_WORKLOAD_REPLAY.IMPORT_AWR (replay_id => 1,
                                          staging_schema => 'capture_awr')
    FROM DUAL;
  

  In this example, the AWR snapshots that correspond to the workload replay with a capture ID of 1 are imported using a staging schema named capture_awr.

  The IMPORT_AWR procedure in this example uses the following parameters:

  • The replay_id required parameter specifies the ID of the replay whose AWR snapshots will be import.

  • The staging_schema required parameter specifies the name of a valid schema in the current database which can be used as a staging area while importing the AWR snapshots from the replay directory to the SYS AWR schema.