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)