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)), round -- MAX_WAIT NUMBER (s.kslesmxt / 10000), s.kslestim, -- TIME_WAITED_MICRO NUMBER d.ksledhash -- EVENT_ID NUMBER from x$ksles s, x$ksled d where s.ksleswts != 0 and s.kslesenm = d.indx

home |  up  |  mailbox