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	NULL	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