PL/SQL Packages DBMS_RESOURCE_MANAGER

Maintain plans, consumer groups, and plan directives.

Subprocedures:
CREATE_PLAN        Create entries which define resource plans. 

CREATE_SIMPLE_PLAN Create a single-level resource plan containing up to
                   eight consumer groups in one step. 

UPDATE_PLAN        Update entries which define resource plans. 

DELETE_PLAN        Delete the specified plan as well as all the plan directives it refers to. 

DELETE_PLAN_CASCADE Delete the specified plan as well as all its descendants
                   (plan directives, subplans, consumer groups). 

CREATE_CONSUMER_GROUP   Create entries which define resource consumer groups. 
UPDATE_CONSUMER_GROUP   Update entries which define resource consumer groups. 
DELETE_CONSUMER_GROUP   Delete entries which define resource consumer groups. 

CREATE_PLAN_DIRECTIVE Create resource plan directives.  
UPDATE_PLAN_DIRECTIVE Update resource plan directives. 
DELETE_PLAN_DIRECTIVE Delete resource plan directives. 

CREATE_PENDING_AREA   Create a work area for changes to resource manager objects. 
VALIDATE_PENDING_AREA Validate pending changes for the resource manager. 
CLEAR_PENDING_AREA    Clear the work area for the resource manager. 
SUBMIT_PENDING_AREA   Submit pending changes for the resource manager. 

SET_INITIAL_CONSUMER_GROUP
                      Assign the initial resource consumer group for a user. 

SWITCH_CONSUMER_GROUP_FOR_SESS
                      Change the resource consumer group of a specific session. 

SWITCH_CONSUMER_GROUP_FOR_USER
                      Change the resource consumer group for all sessions with a
                      given user name.  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al



 
Copyright © 1999-2024 SS64.com
Some rights reserved