The DBMS_RESOURCE_MANAGER package is used to maintain resource plans, resource consumer groups, and resource plan directives.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Privilege requirements
The caller must have the ADMINISTER_RESOURCE_MANAGER system privilege to execute procedures in the DBMS_RESOURCE_MANAGER package.
Subprograms
The following table lists the subprograms of the DBMS_RESOURCE_MANAGER package supported in the current OceanBase Database version and their brief descriptions.
| Subprogram | Description |
|---|---|
| CREATE_CONSUMER_GROUP | Creates a resource consumer group. |
| CREATE_PLAN | Creates a resource plan. |
| CREATE_PLAN_DIRECTIVE | Creates a resource plan directive. |
| COPY_PLAN | Copies an existing resource management plan and its associated resource directives. |
| DELETE_CONSUMER_GROUP | Deletes a resource consumer group. |
| DELETE_PLAN | Deletes a specified plan and all plan directives it references. |
| DELETE_PLAN_DIRECTIVE | Deletes a resource plan directive. |
| SET_CONSUMER_GROUP_MAPPING | Adds, deletes, or modifies entries for mapping login and runtime attributes. |
| UPDATE_PLAN_DIRECTIVE | Updates a resource plan directive. |