The DBMS_RESOURCE_MANAGER package maintains resource plans, resource consumer groups, and resource plan directives.
Privileges
The invoker must have the ADMINISTER_RESOURCE_MANAGER system privilege to execute procedures in the DBMS_RESOURCE_MANAGER package.
Subprograms
The following table describes the DBMS_RESOURCE_MANAGER subprograms supported by the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| CREATE_CONSUMER_GROUP | Creates a resource consumer group. |
| CREATE_PLAN | Creates a resource plan. |
| CREATE_PLAN_DIRECTIVE | Creates a resource plan directive. |
| DELETE_CONSUMER_GROUP | Deletes a resource consumer group. |
| DELETE_PLAN | Deletes a resource plan and all directives referenced by this plan. |
| DELETE_PLAN_DIRECTIVE | Deletes a resource plan directive. |
| SET_CONSUMER_GROUP_MAPPING | Adds, deletes, or modifies an entry of a logon or run-time attribute mapping. |
| UPDATE_PLAN_DIRECTIVE | Updates a resource plan directive. |