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	Description
`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
`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
`COMMENTS`	`VARCHAR2(2000)`	Text comment on the plan
`STATUS`	`VARCHAR2(30)`	Status of the plan: `PENDING` - Plan is part of the pending area `ACTIVE`
`MANDATORY`	`VARCHAR2(3)`	Indicates whether the plan is mandatory (`YES`) or not (`NO`)

See Also:

Oracle Database Administrator's Guide for information on resource plans in general
PL/SQL Packages and Types Reference for more information on creating resource plans with the DBMS_RESOURCE_MANAGER package