Defining Replay Schedules Using APIs

This section describes how to define replay schedules using the DBMS_WORKLOAD_REPLAY package. For information about replay schedules, see "Defining Replay Schedules".

Before defining replay schedules, 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 state is not in replay mode

To define replay schedules:

1. Create a new replay schedule, as described in "Creating Replay Schedules Using APIs".

2. Add workload captures to the replay schedule, as described in "Adding Workload Captures to Replay Schedules Using APIs".

3. Add schedule orders to the replay schedule, as described in "Adding Schedule Orders to Replay Schedules Using APIs".

4. Save the replay schedule, as described in "Saving Replay Schedules Using APIs".