GV$SERVICE_EVENT

select
s.inst_id,               -- INST_ID NUMBER
s.kswsevtabnm,           -- SERVICE_NAME VARCHAR2(64)
s.kswsevtabnmh,          -- SERVICE_NAME_HASH NUMBER
d.kslednam,              -- EVENT VARCHAR2(64)
d.ksledhash,             -- EVENT_ID NUMBER
s.kswsevtabwts,          -- TOTAL_WAITS NUMBER
s.kswsevtabtmo,          -- TOTAL_TIMEOUTS NUMBER
round                    -- TIME_WAITED NUMBER
  (s.kswsevtabtim / 10000),
round                    -- AVERAGE_WAIT NUMBER
  (s.kswsevtabtim / (10000 * s.kswsevtabwts)),
round                    -- MAX_WAIT NUMBER
  (s.kswsevtabmxt / 10000),
s.kswsevtabtim           -- TIME_WAITED_MICRO NUMBER
from
x$kswsevtab s,
x$ksled d 
where
s.kswsevtabwts != 0 and s.kswsevtabnum = d.indx
home |  up  |  mailbox