Просмотр исходного текста страницы Oracle PL/SQL/System Tables Views/dba rsrc plan directives

==Determining the Status of the Resource Plans==



   
  <!-- start source code -->
   
    <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>