The DBMS_WORKLOAD_REPOSITORY package is used to manage the Automatic Workload Repository (AWR).
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Privilege requirements for DBMS_WORKLOAD_REPOSITORY
All subprograms of the DBMS_WORKLOAD_REPOSITORY package require the EXECUTE privilege.
Overview of DBMS_WORKLOAD_REPOSITORY subprograms
The following table lists the DBMS_WORKLOAD_REPOSITORY subprograms supported in the current OceanBase Database version and their brief descriptions.
Subprogram |
Description |
|---|---|
| ASH_REPORT | Displays the ASH report in text format. |