select inst_id, -- INST_ID NUMBER indx, -- SID NUMBER ksusesbg, -- BLOCK_GETS NUMBER ksusescg, -- CONSISTENT_GETS NUMBER ksusespr, -- PHYSICAL_READS NUMBER ksusesbc, -- BLOCK_CHANGES NUMBER ksusescc, -- CONSISTENT_CHANGES NUMBER ksusesor -- OPTIMIZED_PHYSICAL_READS NUMBER from x$ksusio where bitand(ksspaflg,1)!=0 and bitand(ksuseflg,1)!=0