Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>