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

Материал из SQL эксперт
Перейти к: навигация, поиск

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>