GV$EVENT_HISTOGRAM

select
d.inst_id,               -- INST_ID NUMBER
d.indx,                  -- EVENT# NUMBER
d.kslednam,              -- EVENT VARCHAR2(64)
s.kslsesmaxdur,          -- WAIT_TIME_MILLI NUMBER
s.kslsesval              -- WAIT_COUNT NUMBER
from
x$kslseshist s,
x$ksled d 
where
s.kslsesenum = d.indx
home |  up  |  mailbox