GV$SYSTEM_WAIT_CLASS definition in Oracle Database 11.2
GV$SYSTEM_WAIT_CLASS

select
  s.inst_id,                               -- INST_ID NUMBER
  s.kslscsclsid,                           -- WAIT_CLASS_ID NUMBER
  s.kslscscls,                             -- WAIT_CLASS# NUMBER
  s.kslscsclsname,                         -- WAIT_CLASS VARCHAR2(64)
  (s.kslscswts_un + s.kslscswts_fg + s.kslscswts_bg),-- TOTAL_WAITS NUMBER
  round((s.kslscstim_un + s.kslscstim_fg + s.kslscstim_bg)/10000),-- TIME_WAITED NUMBER
  s.kslscswts_fg,                          -- TOTAL_WAITS_FG NUMBER
  round(s.kslscstim_fg/10000)              -- TIME_WAITED_FG NUMBER
from
  x$kslscs s
where
  s.kslscswts_un > 0 or s.kslscswts_fg > 0 or s.kslscswts_un > 0

home |  up