select
  s.inst_id,                               -- INST_ID NUMBER
  s.kslcssid,                              -- SID NUMBER
  s.kslcsser,                              -- SERIAL# NUMBER
  s.kslcsclsid,                            -- WAIT_CLASS_ID NUMBER
  s.kslcscls,                              -- WAIT_CLASS# NUMBER
  s.kslcsclsname,                          -- WAIT_CLASS VARCHAR2(64)
  s.kslcswts,                              -- TOTAL_WAITS NUMBER
  round(s.kslcstim / 10000)                -- TIME_WAITED NUMBER
from
  x$kslcs s
where
  s.kslcswts != 0