GV$SYSTEM_EVENT definition in Oracle Database 11.2
GV$SYSTEM_EVENT
select
d.inst_id, -- INST_ID NUMBER
d.kslednam, -- EVENT VARCHAR2(64)
(s.ksleswts_un + s.ksleswts_fg + s.ksleswts_bg),-- TOTAL_WAITS NUMBER
(s.kslestmo_un + s.kslestmo_fg + s.kslestmo_bg),-- TOTAL_TIMEOUTS NUMBER
round((s.kslestim_un + s.kslestim_fg + s.kslestim_bg)/10000),-- TIME_WAITED NUMBER
round((s.kslestim_un + s.kslestim_fg + s.kslestim_bg)/ (10000 * (s.ksleswts_un + s.ksleswts_fg + s.ksleswts_bg)), 2),-- AVERAGE_WAIT NUMBER
(s.kslestim_un + s.kslestim_fg + s.kslestim_bg),-- TIME_WAITED_MICRO NUMBER
s.ksleswts_fg, -- TOTAL_WAITS_FG NUMBER
s.kslestmo_fg, -- TOTAL_TIMEOUTS_FG NUMBER
round(s.kslestim_fg/10000), -- TIME_WAITED_FG NUMBER
round(s.kslestim_fg/decode(s.ksleswts_fg, 0, 1, 10000 * s.ksleswts_fg), 2),-- AVERAGE_WAIT_FG NUMBER
s.kslestim_fg, -- TIME_WAITED_MICRO_FG 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$kslei s,
x$ksled d
where
(s.ksleswts_un > 0 or s.ksleswts_fg > 0 or s.ksleswts_bg > 0) and s.indx = d.indx