DBA_HIST_SESS_TIME_STATS

   SNAP_ID       DBID INSTANCE_NUMBER
---------- ---------- ---------------
SESSION_TYPE                                                     MIN_LOGON
---------------------------------------------------------------- ---------
SUM_CPU_TIME SUM_SYS_IO_WAIT SUM_USER_IO_WAIT
------------ --------------- ----------------
QMON Coordinator                                                 10-JUN-11
     7950000               0            46769

     13580       9998               1
QMON Slaves                                                      10-JUN-11
    37710000               0        347746180


   SNAP_ID       DBID INSTANCE_NUMBER
---------- ---------- ---------------
SESSION_TYPE                                                     MIN_LOGON
---------------------------------------------------------------- ---------
SUM_CPU_TIME SUM_SYS_IO_WAIT SUM_USER_IO_WAIT
------------ --------------- ----------------
     13581       9998               1
QMON Coordinator                                                 10-JUN-11
     8190000               0            46769


99 rows selected.

SQL> select count(*), session_type from DBA_HIST_SESS_TIME_STATS    group by session_type;

  COUNT(*) SESSION_TYPE
---------- ----------------------------------------------------------------
      1103 QMON Coordinator
      1103 QMON Slaves
Comments