Table: DBA_RSRC_PLANS
All the resource plans
| Column Name | Description |
|---|---|
| ACTIVE_SESS_POOL_MTH | maximum active sessions target resource allocation method for the plan |
| COMMENTS | Text comment on the plan |
| CPU_METHOD | CPU resource allocation method for the plan |
| MANDATORY | Whether the plan is mandatory |
| NUM_PLAN_DIRECTIVES | Number of plan directives for the plan |
| PARALLEL_DEGREE_LIMIT_MTH | parallel degree limit resource allocation method for the plan |
| PLAN | Plan name |
| QUEUEING_MTH | queueing method for groups |
| STATUS | PENDING if it is part of the pending area, ACTIVE otherwise |