Oracle PL/SQL/System Tables Views/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>