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.V_$RSRC_PLAN

Object Details

Object Name:	V_$RSRC_PLAN
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ID	NUMBER
NAME	VARCHAR2	(32)
IS_TOP_PLAN	VARCHAR2	(5)
CPU_MANAGED	VARCHAR2	(3)
INSTANCE_CAGING	VARCHAR2	(3)
PARALLEL_SERVERS_ACTIVE	NUMBER
PARALLEL_SERVERS_TOTAL	NUMBER
PARALLEL_EXECUTION_MANAGED	VARCHAR2	(32)
CON_ID	NUMBER
DIRECTIVE_TYPE	VARCHAR2	(32)
SHARES	NUMBER
UTILIZATION_LIMIT	NUMBER
PARALLEL_SERVER_LIMIT	NUMBER
MEMORY_MIN	NUMBER
MEMORY_LIMIT	NUMBER
PROFILE	VARCHAR2	(32)

Query Text

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


SELECT ID
,      NAME
,      IS_TOP_PLAN
,      CPU_MANAGED
,      INSTANCE_CAGING
,      PARALLEL_SERVERS_ACTIVE
,      PARALLEL_SERVERS_TOTAL
,      PARALLEL_EXECUTION_MANAGED
,      CON_ID
,      DIRECTIVE_TYPE
,      SHARES
,      UTILIZATION_LIMIT
,      PARALLEL_SERVER_LIMIT
,      MEMORY_MIN
,      MEMORY_LIMIT
,      PROFILE
FROM SYS.V_$RSRC_PLAN;

Dependencies

[top of page]

SYS.V_$RSRC_PLAN references the following:

SYS.V_$RSRC_PLAN is referenced by following:

PUBLIC: V$RSRC_PLAN