query V$RSRC_CONSUMER_GROUP to see what the resource usage among the consumer groups looks like: : RSRC_CONSUMER_GROUP « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. RSRC_CONSUMER_GROUP

query V$RSRC_CONSUMER_GROUP to see what the resource usage among the consumer groups looks like:

 
SQL>
SQL> SELECT name,active_sessions,cpu_wait_time, consumed_cpu_time,
  2  current_undo_consumption
  3  FROM v$rsrc_consumer_group;

NAME                             ACTIVE_SESSIONS CPU_WAIT_TIME CONSUMED_CPU_TIME CURRENT_UNDO_CONSUMPTION
-------------------------------- --------------- ------------- ----------------- ------------------------
OTHER_GROUPS                                   1           307             94890                     0

SQL>

 

Related examples in the same category