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 OceanBase AI 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 | Delete snapshots within a range. |
| MODIFY_SNAPSHOT_SETTINGS | Modifies the WORKLOAD_REPOSITORY configuration. |