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 s.kslestim, -- TIME_WAITED NUMBER s.kslestim / s.ksleswts, -- AVERAGE_WAIT NUMBER s.kslesmxt -- MAX_WAIT NUMBER from x$ksles s, x$ksled d where s.ksleswts != 0 and s.kslesenm = d.indx

home |  up  |  mailbox