The DBMS_RESOURCE_MANAGER system package is used to manage resource usage plans, resource usage groups, and resource plan directives.
Privileges
The caller must have the ADMINISTER_RESOURCE_MANAGER system privilege to execute the procedures in the DBMS_RESOURCE_MANAGER system package.
Overview of Subprograms
The following table lists the DBMS_RESOURCE_MANAGER subprograms supported by the current version of OceanBase Database and provides brief descriptions.
subprogram |
Description |
|---|---|
| CREATE_CONSUMER_GROUP | Create a resource usage definition group. |
| CREATE_PLAN | Create a resource plan. |
| CREATE_PLAN_DIRECTIVE | Create a resource plan directive. |
| DELETE_CONSUMER_GROUP | Delete a resource usage group. |
| DELETE_PLAN | Deletes a specified plan and all plan directives it references. |
| DELETE_PLAN_DIRECTIVE | Delete a resource plan directive. |
| SET_CONSUMER_GROUP_MAPPING | Add, delete, or modify entries in the login and runtime attribute mappings. |
| UPDATE_PLAN_DIRECTIVE | Updates the resource plan directive. |