|
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)
|
|
Status of the plan: PENDING if it is part of the pending area, ACTIVE otherwise
|
|
MANDATORY
|
VARCHAR2(3)
|
|
(YES/NO) Indicates whether the plan is mandatory
|
