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
Related Commands:
Related Packages: