select
  s.inst_id,                               -- INST_ID NUMBER
  s.kslessid,                              -- SID NUMBER
  d.kslednam,                              -- EVENT VARCHAR2(64)
  s.ksleswts,                              -- TOTAL_WAITS NUMBER
  s.kslestmo,                              -- TOTAL_TIMEOUTS NUMBER
  round(s.kslestim / 10000),               -- TIME_WAITED NUMBER
  round(s.kslestim / (10000 * s.ksleswts), 2),-- AVERAGE_WAIT NUMBER
  round(s.kslesmxt / 10000),               -- MAX_WAIT NUMBER
  s.kslestim,                              -- TIME_WAITED_MICRO 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$ksles s,
  x$ksled d
where
  s.ksleswts != 0 and s.kslesenm = d.indx