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
from
x$ksuse a,
x$kxfpdp b
where
bitand(a.ksspaflg,1)!=0 and bitand(a.ksuseflg,1)!=0 and a.ksuseqcsid > 0 and a.ksusepro = b.kxfpdppro(+)