Static Data Dictionary Views, 221 of 452

DBA_RSRC_PLANS

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

See Also:

Oracle8i Administrator's Guide for information on resource plans in general.

Oracle8i Supplied PL/SQL Packages Reference for more information on creating resource plans with the DBMS_RESOURCE_MANAGER package.

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
`MAX_ACTIVE_SESS_TARGET_MTH`	`VARCHAR2(30)`	Reserved for future use.
`PARALLEL_DEGREE_LIMIT_MTH`	`VARCHAR2(30)`	Parallel degree limit resource allocation method for the plan
`COMMENTS`	`VARCHAR2(2000)`	Text comment on the plan
`STATUS`	`VARCHAR2(30)`	Status of the plan: `PENDING` if it is part of the pending area, `ACTIVE` otherwise
`MANDATORY`	`VARCHAR2(3)`	Whether the plan is mandatory