GV$MYSTAT 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)