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

VIEW: SYS.DBA_RSRC_PLAN_DIRECTIVES

Object Details
Object Name: DBA_RSRC_PLAN_DIRECTIVES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

all the resource plan directives

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN VARCHAR2 (128)
Name of the plan to which this directive belongs
GROUP_OR_SUBPLAN VARCHAR2 (128)
Name of the consumer group/sub-plan referred to
TYPE VARCHAR2 (14)
Whether GROUP_OR_SUBPLAN refers to a consumer group or a plan
CPU_P1 NUMBER

deprecated - use MGMT_P1
CPU_P2 NUMBER

deprecated - use MGMT_P2
CPU_P3 NUMBER

deprecated - use MGMT_P3
CPU_P4 NUMBER

deprecated - use MGMT_P4
CPU_P5 NUMBER

deprecated - use MGMT_P5
CPU_P6 NUMBER

deprecated - use MGMT_P6
CPU_P7 NUMBER

deprecated - use MGMT_P7
CPU_P8 NUMBER

deprecated - use MGMT_P8
MGMT_P1 NUMBER

first parameter for the resource allocation method
MGMT_P2 NUMBER

second parameter for the resource allocation method
MGMT_P3 NUMBER

third parameter for the resource allocation method
MGMT_P4 NUMBER

fourth parameter for the resource allocation method
MGMT_P5 NUMBER

fifth parameter for the resource allocation method
MGMT_P6 NUMBER

sixth parameter for the resource allocation method
MGMT_P7 NUMBER

seventh parameter for the resource allocation method
MGMT_P8 NUMBER

eight parameter for the resource allocation method
ACTIVE_SESS_POOL_P1 NUMBER

first parameter for the maximum active sessions target resource allocation method
QUEUEING_P1 NUMBER

first parameter for the queueing method
PARALLEL_TARGET_PERCENTAGE NUMBER

PARALLEL_DEGREE_LIMIT_P1 NUMBER

first parameter for the parallel degree limit resource allocation method
SWITCH_GROUP VARCHAR2 (128)
group to switch to once switch time is reached
SWITCH_FOR_CALL VARCHAR2 (5)
switch back to initial consumer group once top call has completed
SWITCH_TIME NUMBER

switch time limit for execution within a group
SWITCH_IO_MEGABYTES NUMBER

maximum megabytes of I/O within a group
SWITCH_IO_REQS NUMBER

maximum I/O requests within a group
SWITCH_ESTIMATE VARCHAR2 (5)
use execution estimate to determine group?
MAX_EST_EXEC_TIME NUMBER

use of maximum estimated execution time
UNDO_POOL NUMBER

maximum undo allocation for consumer groups
MAX_IDLE_TIME NUMBER

maximum idle time
MAX_IDLE_BLOCKER_TIME NUMBER

maximum idle time when blocking other sessions
MAX_UTILIZATION_LIMIT NUMBER

deprecated - use UTILIZATION_LIMIT
PARALLEL_QUEUE_TIMEOUT NUMBER

time that a query can spend on the parallel query queue before timing out
SWITCH_TIME_IN_CALL NUMBER

deprecated - use SWITCH_FOR_CALL and SWITCH_TIME
SWITCH_IO_LOGICAL NUMBER

maximum logical I/O requests within a group
SWITCH_ELAPSED_TIME NUMBER

maximum elapsed time within a group
PARALLEL_SERVER_LIMIT NUMBER

maximum percentage of the parallel target used before queueing subsequent parallel queries
UTILIZATION_LIMIT NUMBER

maximum resource utilization allowed, expressed in percentage
PARALLEL_STMT_CRITICAL VARCHAR2 (12)
queuing policy for critical parallel statements
COMMENTS VARCHAR2 (2000)
Text comment on the plan directive
STATUS VARCHAR2 (128)
PENDING if it is part of the pending area, NULL otherwise
MANDATORY VARCHAR2 (3)
Whether the plan directive is mandatory
Query Text

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


SELECT PLAN
,      GROUP_OR_SUBPLAN
,      TYPE
,      CPU_P1
,      CPU_P2
,      CPU_P3
,      CPU_P4
,      CPU_P5
,      CPU_P6
,      CPU_P7
,      CPU_P8
,      MGMT_P1
,      MGMT_P2
,      MGMT_P3
,      MGMT_P4
,      MGMT_P5
,      MGMT_P6
,      MGMT_P7
,      MGMT_P8
,      ACTIVE_SESS_POOL_P1
,      QUEUEING_P1
,      PARALLEL_TARGET_PERCENTAGE
,      PARALLEL_DEGREE_LIMIT_P1
,      SWITCH_GROUP
,      SWITCH_FOR_CALL
,      SWITCH_TIME
,      SWITCH_IO_MEGABYTES
,      SWITCH_IO_REQS
,      SWITCH_ESTIMATE
,      MAX_EST_EXEC_TIME
,      UNDO_POOL
,      MAX_IDLE_TIME
,      MAX_IDLE_BLOCKER_TIME
,      MAX_UTILIZATION_LIMIT
,      PARALLEL_QUEUE_TIMEOUT
,      SWITCH_TIME_IN_CALL
,      SWITCH_IO_LOGICAL
,      SWITCH_ELAPSED_TIME
,      PARALLEL_SERVER_LIMIT
,      UTILIZATION_LIMIT
,      PARALLEL_STMT_CRITICAL
,      COMMENTS
,      STATUS
,      MANDATORY
FROM SYS.DBA_RSRC_PLAN_DIRECTIVES;

Dependencies

[top of page]

SYS.DBA_RSRC_PLAN_DIRECTIVES references the following:

SchemaSYS
TableRESOURCE_PLAN_DIRECTIVE$
SYS.DBA_RSRC_PLAN_DIRECTIVES is referenced by following:

SchemaPUBLIC
SynonymDBA_RSRC_PLAN_DIRECTIVES
SchemaSYS
ViewDBA_AUTOTASK_CLIENT
Package BodyDBMS_AUTO_TASK_EXPORT - show dependent code