Saving Replay Schedules Using APIs

This section describes how to save replay schedules that been defined using the DBMS_WORKLOAD_REPLAY package.

Before saving a replay schedule, ensure that the following prerequisites are met:

• A replay schedule that will be saved is created.

  For information about creating a replay schedule, see "Creating Replay Schedules Using APIs".

• All workload captures participating in the schedule order are added to the replay schedule.

  For information about adding workload captures to a replay schedule, see "Adding Workload Captures to Replay Schedules Using APIs".

• Any schedule orders that you want to use are added to the replay schedule (this step is optional).

  For information about adding schedule orders to a replay schedule, see "Adding Schedule Orders to Replay Schedules Using APIs".

To save a replay schedule:

• Use the END_REPLAY_SCHEDULE procedure:

  DBMS_WORKLOAD_REPLAY.END_REPLAY_SCHEDULE;
  

  This procedure completes the creation of a replay schedule. The replay schedule is saved and associated with the replay directory. Once a replay schedule is saved, you can use it for a consolidated replay.

To view replay schedules:

• Use the DBA_WORKLOAD_REPLAY_SCHEDULES view.