DBA_RSRC_PLANS

All the resource plans

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

Related Commands:

Simon Sheppard
SS64.com