You can delete information retrieved for either a single workload replay or all workload replays in a given directory object. Deleted information can be retrieved using the GET_REPLAY_INFO
function, as described in "Retrieving Information About Workload Replays".
Alternatively, you can also choose to permanently delete the replay data from disk. Doing so will prevent retrieval of the deleted data.
To delete information about workload replays:
Call the DBMS_WORKLOAD_REPLAY
.DELETE_REPLAY_INFO
procedure using one of the following parameters.
The replay_id
parameter specifies the ID of the workload replay for which you want to delete replay information. Use this parameter if you only want to delete information for a single workload replay.
The replay_dir
parameter specifies the name of the directory object (the value is case-sensitive). Use this parameter if you want to delete information for all workload replays in a given directory object.
By default, deleting information about workload replays does not remove the data from disk.
To delete the replay data from disk and prevent retrieval of the deleted data, set the value of the permanent
parameter to TRUE
(the default value is FALSE
).
Example 12-3 Deleting information about workload replay
The following example deletes information retrieved about the workload captures and the history of the workload replay attempts for the replay directory object named jul14
. The replay data is not deleted from disk, and thus can be retrieved by calling the GET_REPLAY_INFO
function, as described in "Retrieving Information About Workload Replays".
BEGIN DBMS_WORKLOAD_REPLAY.DELETE_REPLAY_INFORMATION (replay_dir => 'jul14'); END; /