PLAN_ID |
NUMBER |
NOT NULL |
ID number of the resource plan |
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 |
MGMT_METHOD |
VARCHAR2(30) |
|
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 |
SUB_PLAN |
VARCHAR2(3) |
|
Indicates whether the plan is a subplan (YES) or not (NO) |
COMMENTS |
VARCHAR2(2000) |
|
Text comment on the plan |
STATUS |
VARCHAR2(30) |
|
Indicates whether the plan is part of the pending area (PENDING) or not (NULL) |
MANDATORY |
VARCHAR2(3) |
|
Indicates whether the plan is mandatory (YES) or not (NO) |
