Preparing for Consolidated Database Replay Using APIs

This section describes how to prepare a consolidated replay using the DBMS_WORKLOAD_REPLAY package. For information about preparing consolidated replays, see "Preparing for Consolidated Database Replay".

Before preparing a consolidated replay, ensure that the following prerequisites are met:

• Replay data is initialized, as described in "Initializing Consolidated Database Replay Using APIs".

• Captured connections are remapped, as described in "Remapping Connection Using APIs".

• Users are mapped, as described in "Remapping Users Using APIs".

  Remapping users is optional. However, if you are planning to remap users during replay, then it must be completed before preparing the consolidated replay.

Preparing a consolidated replay performs the following operations:

• Specifies the replay options, such as synchronization mode (or COMMIT order), session connection rate, and session request rate.

• Puts the database state in replay mode.

• Enables the start of replay clients.

To prepare a consolidated replay:

• Use the PREPARE_CONSOLIDATED_REPLAY procedure:

  DBMS_WORKLOAD_REPLAY.PREPARE_CONSOLIDATED_REPLAY (
     synchronization         IN VARCHAR2 DEFAULT 'OBJECT_ID',
     connect_time_scale      IN NUMBER   DEFAULT 100,
     think_time_scale        IN NUMBER   DEFAULT 100,
     think_time_auto_correct IN BOOLEAN  DEFAULT TRUE,
     capture_sts             IN BOOLEAN  DEFAULT FALSE,
     sts_cap_interval        IN NUMBER   DEFAULT 300);
  

  For information about these parameters and how to set them, see "Specifying Replay Options".