Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Determining the Status of the Resource Plans

SQL> SQL> SELECT plan,group_or_subplan,cpu_p1,cpu_p2,cpu_p3, status   2  FROM dba_rsrc_plan_directives; PLAN                           GROUP_OR_SUBPLAN                   CPU_P1     CPU_P2     CPU_P3 STATUS ------------------------------ ------------------------------ ---------- ---------- ---------- ------------------------------ SYSTEM_PLAN                    SYS_GROUP                             100          0          0 SYSTEM_PLAN                    OTHER_GROUPS                            0        100          0 SYSTEM_PLAN                    LOW_GROUP                               0          0        100 INTERNAL_QUIESCE               SYS_GROUP                               0          0          0 INTERNAL_QUIESCE               OTHER_GROUPS                            0          0          0 INTERNAL_PLAN                  OTHER_GROUPS                            0          0          0 6 rows selected. SQL> SQL>