The DBMS_WORKLOAD_REPOSITORY system package is used to manage the automatic workload repository (WR).
DBMS_WORKLOAD_REPOSITORY Privilege Description
All subprograms of the DBMS_WORKLOAD_REPOSITORY system package require the user to have the EXECUTE privilege.
Overview of the DBMS_WORKLOAD_REPOSITORY Subprogram
The following table lists the DBMS_WORKLOAD_REPOSITORY subprograms supported by the current version of OceanBase Database and provides brief descriptions.
Subprogram |
Description |
|---|---|
| ASH_REPORT | Displays the ASH report in text format. |
| CREATE_SNAPSHOT | Triggers snapshot generation for a cluster. |
| DROP_SNAPSHOT_RANGE | Deletes snapshots within a specified range. |
| MODIFY_SNAPSHOT_SETTINGS | Modify the WORKLOAD_REPOSITORY configuration. |