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 |