home - keyword index

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

home - keyword index

Comment on this page: