GV$SYSTEM_EVENT
select d.inst_id, -- INST_ID 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)), s.kslestim, -- TIME_WAITED_MICRO NUMBER d.ksledhash -- EVENT_ID NUMBER from x$kslei s, x$ksled d where s.ksleswts != 0 and s.indx = d.indx

home |  up  |  mailbox