eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.CDB_RSRC_PLANS

Object Details

Object Name:	CDB_RSRC_PLANS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All the resource plans in all containers

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	Plan ID
PLAN	VARCHAR2	(128)		Plan name
NUM_PLAN_DIRECTIVES	NUMBER			Number of plan directives for the plan
CPU_METHOD	VARCHAR2	(128)		deprecated - use MGMT_METHOD
MGMT_METHOD	VARCHAR2	(128)		resource allocation method for the plan
ACTIVE_SESS_POOL_MTH	VARCHAR2	(128)		maximum active sessions target resource allocation method for the plan
PARALLEL_DEGREE_LIMIT_MTH	VARCHAR2	(128)		parallel degree limit resource allocation method for the plan
QUEUEING_MTH	VARCHAR2	(128)		queueing method for groups
SUB_PLAN	VARCHAR2	(3)		Whether the plan is a sub-plan
COMMENTS	VARCHAR2	(2000)		Text comment on the plan
STATUS	VARCHAR2	(128)		PENDING if it is part of the pending area, NULL otherwise
MANDATORY	VARCHAR2	(3)		Whether the plan is mandatory
CON_ID	NUMBER			container id

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLAN_ID
,      PLAN
,      NUM_PLAN_DIRECTIVES
,      CPU_METHOD
,      MGMT_METHOD
,      ACTIVE_SESS_POOL_MTH
,      PARALLEL_DEGREE_LIMIT_MTH
,      QUEUEING_MTH
,      SUB_PLAN
,      COMMENTS
,      STATUS
,      MANDATORY
,      CON_ID
FROM SYS.CDB_RSRC_PLANS;

Dependencies

[top of page]

SYS.CDB_RSRC_PLANS does not reference any database object

SYS.CDB_RSRC_PLANS is referenced by following:

PUBLIC: CDB_RSRC_PLANS