[Home] [Help] [Dependency Information]
Object Name: | RESOURCE_PLAN_DIRECTIVE$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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$;
SYS.RESOURCE_PLAN_DIRECTIVE$ does not reference any database object
SYS.RESOURCE_PLAN_DIRECTIVE$ is referenced by following:
|
|
|