The DBMS_RESOURCE_MANAGER package is used to manage resource plans, resource consumer groups, and resource plan directives.
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 DBMS_RESOURCE_MANAGER subprograms supported in the current version of OceanBase Database 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 existing resource plan 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 in login and runtime attribute mappings. |
| UPDATE_PLAN_DIRECTIVE | Updates a resource plan directive. |