select
  s.inst_id,                               -- INST_ID NUMBER
  s.kswsevtabnm,                           -- SERVICE_NAME VARCHAR2(64)
  s.kswsevtabnmh,                          -- SERVICE_NAME_HASH NUMBER
  d.kslednam,                              -- EVENT VARCHAR2(64)
  d.ksledhash,                             -- EVENT_ID NUMBER
  s.kswsevtabwts,                          -- TOTAL_WAITS NUMBER
  s.kswsevtabtmo,                          -- TOTAL_TIMEOUTS NUMBER
  round(s.kswsevtabtim / 10000),           -- TIME_WAITED NUMBER
  round(s.kswsevtabtim / (10000 * s.kswsevtabwts)),-- AVERAGE_WAIT NUMBER
  round(s.kswsevtabmxt / 10000),           -- MAX_WAIT NUMBER
  s.kswsevtabtim                           -- TIME_WAITED_MICRO NUMBER
from
  x$kswsevtab s,
  x$ksled d
where
  s.kswsevtabwts != 0 and s.kswsevtabnum = d.indx