Replaying a Database Workload Using APIs

This section describes how to replay a database workload using the DBMS_WORKLOAD_REPLAY package. You can also use Oracle Enterprise Manager to replay a database workload, as described in "Replaying a Database Workload Using Enterprise Manager".

Replaying a database workload using the DBMS_WORKLOAD_REPLAY package is a multi-step process that involves:

• Initializing Replay Data

• Remapping Connections

• Setting Workload Replay Options

• Defining Workload Replay Filters and Replay Filter Sets

• Setting the Replay Timeout Action

• Starting a Workload Replay

• Pausing a Workload Replay

• Resuming a Workload Replay

• Cancelling a Workload Replay

• Retrieving Information About Workload Replays

• Loading Divergence Data for Workload Replay

• Deleting Information About Workload Replays

• Exporting AWR Data for Workload Replay

• Importing AWR Data for Workload Replay