GV$SESSION_EVENT

select
s.inst_id,               -- INST_ID NUMBER
s.kslessid,              -- SID NUMBER
d.kslednam,              -- EVENT VARCHAR2(64)
s.ksleswts,              -- TOTAL_WAITS NUMBER
s.kslestmo,              -- TOTAL_TIMEOUTS NUMBER
round                    -- TIME_WAITED NUMBER
  (s.kslestim / 10000),
round                    -- AVERAGE_WAIT NUMBER
  (s.kslestim / (10000 * s.ksleswts), 2),
round                    -- MAX_WAIT NUMBER
  (s.kslesmxt / 10000),
s.kslestim,              -- TIME_WAITED_MICRO NUMBER
d.ksledhash,             -- EVENT_ID NUMBER
d.ksledclassid,          -- WAIT_CLASS_ID NUMBER
d.ksledclass#,           -- WAIT_CLASS# NUMBER
d.ksledclass             -- WAIT_CLASS VARCHAR2(64)
from
x$ksles s,
x$ksled d 
where
s.ksleswts != 0 and s.kslesenm = d.indx
home |  up  |  mailbox