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 SS64.com 1999-2013
Some rights reserved