Running Consolidated Database Replay Using APIs

This section describes how to run Consolidated Database Replay using the DBMS_WORKLOAD_REPLAY package. For information about consolidated replay, see "Replaying Database Workloads for Consolidated Database Replay".

Before running Consolidated Database Replay, ensure that the following prerequisites are met:

  • All workload captures are preprocessed using the PROCESS_CAPTURE procedure on a system running the same database version as the replay system, as described in Preprocessing a Database Workload .

  • All capture directories are copied to the replay directory on the replay system

  • Replay directory is set using the SET_REPLAY_DIRECTORY procedure, as described in "Setting the Consolidated Replay Directory Using APIs".

  • Database is logically restored to the same application state as that of all the capture systems at the start time of all workload captures.

To run Consolidated Database Replay:

  1. Initialize the replay data, as described in "Initializing Consolidated Database Replay Using APIs".

  2. Remap connections strings, as described in "Remapping Connection Using APIs".

  3. Remap users, as described in "Remapping Users Using APIs".

    Remapping users is optional.

  4. Prepare the consolidated replay, as described in "Preparing for Consolidated Database Replay Using APIs".

  5. Set up and start the replay clients, as described in "Setting Up Replay Clients".

  6. Start the consolidated replay, as described in "Starting Consolidated Database Replay Using APIs".

  7. Generate reports and perform analysis, as described in "Reporting and Analysis for Consolidated Database Replay".