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]

TABLE: SYS.RESOURCE_PLAN_DIRECTIVE$

Object Details

Object Name:	RESOURCE_PLAN_DIRECTIVE$
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length	Mandatory
OBJ#	NUMBER		Yes
PLAN	VARCHAR2	(128)
GROUP_OR_SUBPLAN	VARCHAR2	(128)
IS_SUBPLAN	NUMBER		Yes
DESCRIPTION	VARCHAR2	(2000)
MANDATORY	NUMBER
CPU_P1	NUMBER
CPU_P2	NUMBER
CPU_P3	NUMBER
CPU_P4	NUMBER
CPU_P5	NUMBER
CPU_P6	NUMBER
CPU_P7	NUMBER
CPU_P8	NUMBER
MAX_ACTIVE_SESS_TARGET_P1	NUMBER
PARALLEL_DEGREE_LIMIT_P1	NUMBER
STATUS	VARCHAR2	(128)
ACTIVE_SESS_POOL_P1	NUMBER
QUEUEING_P1	NUMBER
SWITCH_GROUP	VARCHAR2	(128)
SWITCH_TIME	NUMBER
SWITCH_ESTIMATE	NUMBER
MAX_EST_EXEC_TIME	NUMBER
UNDO_POOL	NUMBER
MAX_IDLE_TIME	NUMBER
MAX_IDLE_BLOCKER_TIME	NUMBER
SWITCH_BACK	NUMBER
MGMT_P1	NUMBER
MGMT_P2	NUMBER
MGMT_P3	NUMBER
MGMT_P4	NUMBER
MGMT_P5	NUMBER
MGMT_P6	NUMBER
MGMT_P7	NUMBER
MGMT_P8	NUMBER
SWITCH_FOR_CALL	NUMBER
SWITCH_IO_MEGABYTES	NUMBER
SWITCH_IO_REQS	NUMBER
MAX_UTILIZATION_LIMIT	NUMBER
PARALLEL_QUEUE_TIMEOUT	NUMBER
PARALLEL_SERVER_LIMIT	NUMBER
SWITCH_IO_LOGICAL	NUMBER
SWITCH_ELAPSED_TIME	NUMBER
PARALLEL_STMT_CRITICAL	NUMBER

Query Text

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


SELECT OBJ#
,      PLAN
,      GROUP_OR_SUBPLAN
,      IS_SUBPLAN
,      DESCRIPTION
,      MANDATORY
,      CPU_P1
,      CPU_P2
,      CPU_P3
,      CPU_P4
,      CPU_P5
,      CPU_P6
,      CPU_P7
,      CPU_P8
,      MAX_ACTIVE_SESS_TARGET_P1
,      PARALLEL_DEGREE_LIMIT_P1
,      STATUS
,      ACTIVE_SESS_POOL_P1
,      QUEUEING_P1
,      SWITCH_GROUP
,      SWITCH_TIME
,      SWITCH_ESTIMATE
,      MAX_EST_EXEC_TIME
,      UNDO_POOL
,      MAX_IDLE_TIME
,      MAX_IDLE_BLOCKER_TIME
,      SWITCH_BACK
,      MGMT_P1
,      MGMT_P2
,      MGMT_P3
,      MGMT_P4
,      MGMT_P5
,      MGMT_P6
,      MGMT_P7
,      MGMT_P8
,      SWITCH_FOR_CALL
,      SWITCH_IO_MEGABYTES
,      SWITCH_IO_REQS
,      MAX_UTILIZATION_LIMIT
,      PARALLEL_QUEUE_TIMEOUT
,      PARALLEL_SERVER_LIMIT
,      SWITCH_IO_LOGICAL
,      SWITCH_ELAPSED_TIME
,      PARALLEL_STMT_CRITICAL
FROM SYS.RESOURCE_PLAN_DIRECTIVE$;

Dependencies

[top of page]

SYS.RESOURCE_PLAN_DIRECTIVE$ does not reference any database object

SYS.RESOURCE_PLAN_DIRECTIVE$ is referenced by following:

SYS: DBA_RSRC_PLAN_DIRECTIVES; DBMS_PRVTRMIE - show dependent code; DBMS_PRVTRMIE - show dependent code; DBMS_RMGR_PACT_EXPORT - show dependent code; DBMS_RMIN_SYS - show dependent code; DBMS_WLM - show dependent code; KU$_RMGR_PLAN_DIRECT_VIEW