v$system_event


select * from  v$system_event order by TIME_WAITED desc;
EVENT                          TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED  AVERAGE_WAIT
------------------------------ ----------- -------------- ----------- -------------
rdbms ipc message                    50636          50627    22742557        449.14
pmon timer                           25292          25292     7589559        300.08
smon timer                             255            252     7560453      29648.84
SQL*Net message from client            673              0     1084516       1611.47
db file sequential read                461              0         200           .43
rdbms ipc reply                          6              0         137         22.83
control file parallel write             17              0          71          4.18
db file scattered read                 803              0          60           .07
db file single write                    10              0          18          1.80
db file parallel write                   3              0          15          5.00
log file single write                    4              0          13          3.25
log file parallel write                  4              0          10          2.50
process startup                          5              0           6          1.20
log file sync                            2              0           4          2.00
SQL*Net break/reset to client           25              0           3           .12
control file sequential read           106              0           2           .02
log file sequential read                 4              0           0           .00
SQL*Net message to client              674              0           0           .00
instance state change                    1              0           0           .00

19 rows selected.


SVRMGR> desc v$system_event;
Column Name Null? Type
------------------------------ -------- ----
EVENT VARCHAR2(64)
TOTAL_WAITS NUMBER
TOTAL_TIMEOUTS NUMBER
TIME_WAITED NUMBER
AVERAGE_WAIT NUMBER

set heading on
set pagesize 10000
set feedback on
column EVENT format A30;
column TOTAL_WAITS format 999999999
column TOTAL_TIMEOUTS format 999999999
column TIME_WAITED format 999999999
column AVERAGE_WAIT format 999999999.99
select * from  v$system_event order by TIME_WAITED desc;


Questions or comments ? Send a note to khailey@fr.oracle.com