[Home] [Help] [Dependency Information]
Object Name: | CDB_RSRC_PLAN_DIRECTIVES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
all the resource plan directives in all containers
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 | |
CON_ID | NUMBER | container id |
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
, CON_ID
FROM SYS.CDB_RSRC_PLAN_DIRECTIVES;
SYS.CDB_RSRC_PLAN_DIRECTIVES does not reference any database object
SYS.CDB_RSRC_PLAN_DIRECTIVES is referenced by following:
|
|
|