Oracle PL/SQL/System Tables Views/dba rsrc plan directives

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>