DBA_RSRC_PLAN_DIRECTIVES

all the resource plan directives

Columns
   ___________________________
 
   PLAN
      Name of the plan to which this directive belongs
   GROUP_OR_SUBPLAN
      Name of the consumer group/sub-plan referred to
   TYPE
      Whether GROUP_OR_SUBPLAN refers to a consumer group or a plan
   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
   ACTIVE_SESS_POOL_P1
      first parameter for the maximum active sessions target resource allocationmethod
   QUEUEING_P1
      first parameter for the queueing method
   PARALLEL_DEGREE_LIMIT_P1
      first parameter for the parallel degree limit resource allocation method
   SWITCH_GROUP
      group to switch to once switch time is reached
   SWITCH_TIME
      switch time limit for execution within a group
   SWITCH_ESTIMATE
      use execution estimate to determine group?
   MAX_EST_EXEC_TIME
      use of max. estimated execution time
   UNDO_POOL
      max. undo allocation for consumer groups
   COMMENTS
      Text comment on the plan directive
   STATUS
      PENDING if it is part of the pending area,ACTIVE otherwise
   MANDATORY
      Whether the plan directive is mandatory

Related:

DBA_RSRC_PLANS


© Copyright SS64.com 1999-2014
Some rights reserved