select
  inst_id,                                 -- INST_ID NUMBER
  ksqsttyp,                                -- EQ_TYPE VARCHAR2(2)
  sum(ksqstreq),                           -- TOTAL_REQ# NUMBER
  sum(ksqstwat),                           -- TOTAL_WAIT# NUMBER
  sum(ksqstsgt),                           -- SUCC_REQ# NUMBER
  sum(ksqstfgt),                           -- FAILED_REQ# NUMBER
  sum(ksqstwtm)                            -- CUM_WAIT_TIME NUMBER
from
  X$KSQST
group by
  inst_id,
  ksqsttyp
having
  sum(ksqstreq) > 0