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 ) |