GV$SYSTEM_EVENT

select
d.inst_id,               -- INST_ID NUMBER
d.kslednam,              -- EVENT VARCHAR2(64)
s.ksleswts,              -- TOTAL_WAITS NUMBER
s.kslestmo,              -- TOTAL_TIMEOUTS NUMBER
s.kslestim,              -- TIME_WAITED NUMBER
s.kslestim / s.ksleswts  -- AVERAGE_WAIT NUMBER
from
x$kslei s,
x$ksled d 
where
s.ksleswts != 0 and s.indx = d.indx
home |  up  |  mailbox