GV$SESSION_EVENT definition in Oracle 9i / www.oracledba.ru
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
from
x$ksles s,
x$ksled d
where
s.ksleswts != 0 and s.kslesenm = d.indx