Top Event

Hi,

on 11.2.0.3 , on Unix

in AWR report we have :

Top 5 Timed Foreground Events

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

                                                           Avg

                                                          wait   % DB

Event                                 Waits     Time(s)   (ms)   time Wait Class

------------------------------ ------------ ----------- ------ ------ ----------

db file sequential read           2,829,703       6,900      2   39.3 User I/O

control file single write             2,248       5,114   2275   29.1 System I/O

DB CPU                                            2,328          13.2

db file scattered read               75,692         925     12    5.3 User I/O

direct path read                    114,093         611      5    3.5 User I/O

And for the following query :

SELECT E.EVENT, E.WAIT_CLASS,

      TIME_WAITED_MICRO,ROUND(TIME_WAITED_MICRO*100/S.DBTIME,1) PCT_DB_TIME

  FROM V$SYSTEM_EVENT E, V$EVENT_NAME N,

    (SELECT VALUE DBTIME FROM V$SYS_TIME_MODEL WHERE STAT_NAME = 'DB time') S