select
  a.inst_id,                               -- INST_ID NUMBER
  a.addr,                                  -- SADDR RAW(8)
  a.indx,                                  -- SID NUMBER
  a.ksuseser,                              -- SERIAL# NUMBER
  decode(                                  -- QCSID NUMBER
    b.kxfpdpqcsid,NULL,a.indx,b.kxfpdpqcsid),
  b.kxfpdpqcser,                           -- QCSERIAL# NUMBER
  b.kxfpdpcin,                             -- QCINST_ID NUMBER
  b.kxfpdpsvgrp,                           -- SERVER_GROUP NUMBER
  b.kxfpdpsvset,                           -- SERVER_SET NUMBER
  b.kxfpdpsvnum,                           -- SERVER# NUMBER
  b.kxfpdpadg,                             -- DEGREE NUMBER
  b.kxfpdprdg,                             -- REQ_DEGREE NUMBER
  c.ksusestn,                              -- STATISTIC# NUMBER
  c.ksusestv                               -- VALUE NUMBER
from
  x$ksuse a,
  x$kxfpdp b,
  x$ksusesta c
where
  bitand(a.ksspaflg,1)!=0 and bitand(a.ksuseflg,1)!=0 and a.KSUSEQCSID > 0 and a.ksusepro = b.kxfpdppro(+) and a.indx = c.ksusenum and c.ksusestn < (
  select
    ksusgstl
  from
    x$ksusgif)