Table: DBA_RSRC_PLAN_DIRECTIVES
all the resource plan directives
Column Name | Description |
---|---|
ACTIVE_SESS_POOL_P1 | first parameter for the maximum active sessions target resource allocation method |
COMMENTS | Text comment on the plan directive |
CPU_P1 | first parameter for the CPU resource allocation method |
CPU_P2 | second parameter for the CPU resource allocation method |
CPU_P3 | third parameter for the CPU resource allocation method |
CPU_P4 | fourth parameter for the CPU resource allocation method |
CPU_P5 | fifth parameter for the CPU resource allocation method |
CPU_P6 | sixth parameter for the CPU resource allocation method |
CPU_P7 | seventh parameter for the CPU resource allocation method |
CPU_P8 | eight parameter for the CPU resource allocation method |
GROUP_OR_SUBPLAN | Name of the consumer group/sub-plan referred to |
MANDATORY | Whether the plan directive is mandatory |
MAX_EST_EXEC_TIME | use of max. estimated execution time |
PARALLEL_DEGREE_LIMIT_P1 | first parameter for the parallel degree limit resource allocation method |
PLAN | Name of the plan to which this directive belongs |
QUEUEING_P1 | first parameter for the queueing method |
STATUS | PENDING if it is part of the pending area, ACTIVE otherwise |
SWITCH_ESTIMATE | use execution estimate to determine group? |
SWITCH_GROUP | group to switch to once switch time is reached |
SWITCH_TIME | switch time limit for execution within a group |
TYPE | Whether GROUP_OR_SUBPLAN refers to a consumer group or a plan |
UNDO_POOL | max. undo allocation for consumer groups |