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

home |  up