The DBMS_RESOURCE_MANAGER package maintains resource plans, resource consumer groups, and resource plan directives.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
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. |