select
  st.inst_id,                              -- INST_ID NUMBER
  eqt.name,                                -- EQ_NAME VARCHAR2(64)
  st.ksqsttyp,                             -- EQ_TYPE VARCHAR2(2)
  st.ksqstrsn,                             -- REQ_REASON VARCHAR2(64)
  st.ksqstreq,                             -- TOTAL_REQ# NUMBER
  st.ksqstwat,                             -- TOTAL_WAIT# NUMBER
  st.ksqstsgt,                             -- SUCC_REQ# NUMBER
  st.ksqstfgt,                             -- FAILED_REQ# NUMBER
  st.ksqstwtm,                             -- CUM_WAIT_TIME NUMBER
  st.ksqstexpl,                            -- REQ_DESCRIPTION VARCHAR2(4000)
  st.ksqstevidx                            -- EVENT# NUMBER
from
  X$KSQST st,
  X$KSQEQTYP eqt
where
  (st.inst_id = eqt.inst_id) and (st.ksqsttyp = eqt.resname) and (st.indx > 0)