DBA_RSRC_PLAN_DIRECTIVES

Columns
   ___________________________
 
   STATUS
      PENDING if it is part of the pending area, ACTIVE otherwise
   CPU_P3
      third parameter for the CPU resource allocation method
   MANDATORY
      Whether the plan directive is mandatory
   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
   MAX_ACTIVE_SESS_TARGET_P1
      first parameter for the maximum active sessions target resource allocation method
   COMMENTS
      Text comment on the plan directive
   CPU_P2
      second parameter for the CPU resource allocation method
   PARALLEL_DEGREE_LIMIT_P1
      first parameter for the parallel degree limit resource allocation method
   TYPE
      Whether GROUP_OR_SUBPLAN refers to a consumer group or a plan
   GROUP_OR_SUBPLAN
      Name of the consumer group/sub-plan referred to
   PLAN
      Name of the plan to which this directive belongs
   CPU_P1
      first parameter for the CPU resource allocation method
   CPU_P4
      fourth parameter for the CPU resource allocation method

Related Commands: