Skip to main content

Overview

The DBMS_RESOURCE_MANAGER package is used to manage resource plans, resource consumer 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 package.

Subprograms

The following table lists the DBMS_RESOURCE_MANAGER subprograms supported by seekdb and provides a brief description of each.

SubprogramDescription
CREATE_CONSUMER_GROUPCreates a resource consumer group.
CREATE_PLANCreates a resource plan.
CREATE_PLAN_DIRECTIVECreates a resource plan directive.
DELETE_CONSUMER_GROUPDeletes a resource consumer group.
DELETE_PLANDeletes a specified plan and all plan directives that it references.
DELETE_PLAN_DIRECTIVEDeletes a resource plan directive.
SET_CONSUMER_GROUP_MAPPINGAdds, deletes, or modifies entries for login and runtime attribute mappings.
UPDATE_PLAN_DIRECTIVEUpdates a resource plan directive.