|
PLAN
|
VARCHAR2(30)
|
Name of the plan to which this directive belongs
|
|
GROUP_OR_SUBPLAN
|
VARCHAR2(30)
|
Name of the consumer group or subplan referred to
|
|
TYPE
|
VARCHAR2(14)
|
Whether GROUP_OR_SUBPLAN refers to a consumer group or plan
|
|
CPU_P1
|
NUMBER
|
First parameter for the CPU resource allocation method
|
|
CPU_P2
|
NUMBER
|
Second parameter for the CPU resource allocation method
|
|
CPU_P3
|
NUMBER
|
Third parameter for the CPU resource allocation method
|
|
CPU_P4
|
NUMBER
|
Fourth parameter for the CPU resource allocation method
|
|
CPU_P5
|
NUMBER
|
Fifth parameter for the CPU resource allocation method
|
|
CPU_P6
|
NUMBER
|
Sixth parameter for the CPU resource allocation method
|
|
CPU_P7
|
NUMBER
|
Seventh parameter for the CPU resource allocation method
|
|
CPU_P8
|
NUMBER
|
Eighth parameter for the CPU resource allocation method
|
|
ACTIVE_SESS_POOL_P1
|
NUMBER
|
First parameter for the active session pool resource allocation method
|
|
QUEUING_P1
|
NUMBER
|
First parameter for the queuing resource allocation method
|
|
PARALLEL_DEGREE_LIMIT_P1
|
NUMBER
|
First parameter for the parallel degree limit resource allocation method
|
|
SWITCH_GROUP
|
VARCHAR2(30)
|
Group to switch into
|
|
SWITCH_TIME
|
NUMBER
|
Amount of run time before session is automatically switched
|
|
SWITCH_ESTIMATE
|
VARCHAR2(5)
|
(TRUE/FALSE) TRUE indicates estimated execution time should be used for switch criteria
|
|
MAX_EST_EXEC_TIME
|
NUMBER
|
First parameter for the maximum estimated execution time
|
|
UNDO_POOL
|
NUMBER
|
Undo pool size for the consumer group
|
|
COMMENTS
|
VARCHAR2(2000)
|
Text comment on the plan directive
|
|
STATUS
|
VARCHAR2(30)
|
Status of the directive: PENDING if it is part of the pending area, ACTIVE otherwise
|
|
MANDATORY
|
VARCHAR2(3)
|
Whether the plan is mandatory (YES | NO)
|
