select inst_id, -- INST_ID NUMBER ksusenum, -- SID NUMBER ksusestn, -- STATISTIC# NUMBER ksusestv -- VALUE NUMBER from x$ksumysta where bitand(ksspaflg,1)!=0 and bitand(ksuseflg,1)!=0 and ksusestn<( select ksusgstl from x$ksusgif)