The DBMS_WORKLOAD_REPOSITORY package manages the Automatic Workload Repository (AWR).
Privileges
To call the subprograms of the DBMS_WORKLOAD_REPOSITORY package, you must have the EXECUTE privilege.
Subprograms
The following table describes the DBMS_WORKLOAD_REPOSITORY subprograms supported by the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| ASH_REPORT | Displays the Active Session History (ASH) report in text. |
| CREATE_SNAPSHOT | Triggers the generation of a snapshot for a cluster. |
| DROP_SNAPSHOT_RANGE | Drops snapshots within the specified range. |
| MODIFY_SNAPSHOT_SETTINGS | Modifies the WORKLOAD_REPOSITORY settings. |