Stopping a Workload Capture

This section describes how to stop a workload capture.

To stop a workload capture:

  • Use the FINISH_CAPTURE procedure:

    BEGIN
      DBMS_WORKLOAD_CAPTURE.FINISH_CAPTURE (); 
    END;
    /
    

    In this example, the FINISH_CAPTURE procedure finalizes the workload capture and returns the database to a normal state.

Tip:

After capturing a workload on the production system, you need to preprocess the captured workload, as described in Preprocessing a Database Workload .