Pausing a Workload Replay

Pausing a workload replay will halt all subsequent user calls issued by the replay clients until the workload replay is either resumed or cancelled. User calls that are already in progress will be allowed to complete. This option enables you to temporarily stop the replay to perform a change and observe its impact for the remainder of the replay.

To pause a workload replay:

  • Use the PAUSE_REPLAY procedure:

    BEGIN
      DBMS_WORKLOAD_REPLAY.PAUSE_REPLAY ();
    END;
    /