PLAN |
VARCHAR2(30) |
|
Name of the resource plan |
NUM_PLAN_DIRECTIVES |
NUMBER |
|
Number of plan directives for the plan |
CPU_METHOD |
VARCHAR2(30) |
|
CPU resource allocation method for the plan |
ACTIVE_SESS_POOL_MTH |
VARCHAR2(30) |
|
Active session pool resource allocation method for the plan |
PARALLEL_DEGREE_LIMIT_MTH |
VARCHAR2(30) |
|
Parallel degree limit resource allocation method for the plan |
QUEUING_MTH |
VARCHAR2(30) |
|
Queuing resource allocation method for the plan |
COMMENTS |
VARCHAR2(2000) |
|
Text comment on the plan |
STATUS |
VARCHAR2(30) |
|
PENDING. if plan is part of the pending area; NULL otherwise. |
MANDATORY |
VARCHAR2(3) |
|
Indicates whether the plan is mandatory (YES) or not (NO) |
