GV$SERVICE_WAIT_CLASS definition in Oracle Database 11.2
GV$SERVICE_WAIT_CLASS

select
  s.inst_id,                               -- INST_ID NUMBER
  s.kswsclstabnm,                          -- SERVICE_NAME VARCHAR2(64)
  s.kswsclstabnmh,                         -- SERVICE_NAME_HASH NUMBER
  s.kswsclsid,                             -- WAIT_CLASS_ID NUMBER
  s.kswsclsnum,                            -- WAIT_CLASS# NUMBER
  s.kswsclsname,                           -- WAIT_CLASS VARCHAR2(64)
  s.kswsclswts,                            -- TOTAL_WAITS NUMBER
  round(s.kswsclstim / 10000)              -- TIME_WAITED NUMBER
from
  x$kswsclstab s
where
  s.kswsclswts != 0

home |  up