Determining the Status of the Resource Plans : dba_rsrc_plan_directives « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. 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>

 

Related examples in the same category