DBA_RSRC_PLANS

DBA_RSRC_PLANS displays information about all resource plans in the database. For a list of currently active plans, see "V$RSRC_PLAN".

Column Datatype NULL Description
PLAN_ID NUMBER NOT NULL ID number of the resource plan
PLAN VARCHAR2(30)   Name of the resource plan
NUM_PLAN_DIRECTIVES NUMBER   Number of plan directives for the plan
CPU_METHOD VARCHAR2(30)   CPU resource allocation method for the plan
MGMT_METHOD VARCHAR2(30)   Resource allocation method for the plan
ACTIVE_SESS_POOL_MTH VARCHAR2(30)   Active session pool resource allocation method for the plan
PARALLEL_DEGREE_LIMIT_MTH VARCHAR2(30)   Parallel degree limit resource allocation method for the plan
QUEUING_MTH VARCHAR2(30)   Queuing resource allocation method for the plan
SUB_PLAN VARCHAR2(3)   Indicates whether the plan is a subplan (YES) or not (NO)
COMMENTS VARCHAR2(2000)   Text comment on the plan
STATUS VARCHAR2(30)   Indicates whether the plan is part of the pending area (PENDING) or not (NULL)
MANDATORY VARCHAR2(3)   Indicates whether the plan is mandatory (YES) or not (NO)

See Also: