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 |
MAX_ACTIVE_SESS_TARGET_P1 |
NUMBER |
|
Reserved for future use. |
PARALLEL_DEGREE_LIMIT_P1 |
NUMBER |
|
First parameter for the parallel degree limit resource allocation method |
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 |