53
DBMS_RESOURCE_MANAGER

The DBMS_RESOURCE_MANAGER package maintains plans, consumer groups, and plan directives. It also provides semantics so that you may group together changes to the plan schema.

See Also: For more information on using the Database Resource Manager, see Oracle9i Database Administrator's Guide.

This chapter discusses the following topics:

• Summary of DBMS_LOB Subprograms

Requirements

The invoker must have the ADMINISTER_RESOURCE_MANAGER system privilege to execute these procedures. The procedures to grant and revoke this privilege are in the package DBMS_RESOURCE_MANAGER_PRIVS.

Summary of DBMS_RESOURE_MANAGER Subprograms

Table 53-1 DBMS_RESOURCE_MANAGER Package Subprograms

Subprogram	Description
"CREATE_PLAN Procedure"	Creates entries which define resource plans.
"CREATE_SIMPLE_PLAN Procedure"	Creates a single-level resource plan containing up to eight consumer groups in one step.
"UPDATE_PLAN Procedure"	Updates entries which define resource plans.
"DELETE_PLAN Procedure"	Deletes the specified plan as well as all the plan directives it refers to.
"DELETE_PLAN_CASCADE Procedure"	Deletes the specified plan as well as all its descendants (plan directives, subplans, consumer groups).
"CREATE_CONSUMER_GROUP Procedure"	Creates entries which define resource consumer groups.
"UPDATE_CONSUMER_GROUP Procedure"	Updates entries which define resource consumer groups.
"DELETE_CONSUMER_GROUP Procedure"	Deletes entries which define resource consumer groups.
"CREATE_PLAN_DIRECTIVE Procedure"	Creates resource plan directives.
"UPDATE_PLAN_DIRECTIVE Procedure"	Updates resource plan directives.
"DELETE_PLAN_DIRECTIVE Procedure"	Deletes resource plan directives.
"CREATE_PENDING_AREA Procedure"	Creates a work area for changes to resource manager objects.
"VALIDATE_PENDING_AREA Procedure"	Validates pending changes for the resource manager.
"CLEAR_PENDING_AREA Procedure"	Clears the work area for the resource manager.
SUBMIT_PENDING_AREA Procedure	Submits pending changes for the resource manager.
"SET_INITIAL_CONSUMER_GROUP Procedure"	Assigns the initial resource consumer group for a user.
"SWITCH_CONSUMER_GROUP_FOR_SESS Procedure"	Changes the resource consumer group of a specific session.
"SWITCH_CONSUMER_GROUP_FOR_USER Procedure"	Changes the resource consumer group for all sessions with a given user name.