DBA_RSRC_PLANS

Columns
   ___________________________
 
   PLAN
      Plan name
   NUM_PLAN_DIRECTIVES
      Number of plan directives for the plan
   CPU_METHOD
      CPU resource allocation method for the plan
   ACTIVE_SESS_POOL_MTH
      maximum active sessions target resource allocation method for the plan
   PARALLEL_DEGREE_LIMIT_MTH
      parallel degree limit resource allocation method for the plan
   QUEUEING_MTH
      queueing method for groups
   COMMENTS
      Text comment on the plan
   STATUS
      PENDING if it is part of the pending area,ACTIVE otherwise
   MANDATORY
      Whether the plan is mandatory

Related: