Oracle PL/SQL/System Tables Views/dba rsrc plan directives
Determining the Status of the Resource Plans
<source lang="sql">
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>
</source>