GV$SESS_IO
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 from x$ksusio where bitand (ksspaflg, 1) !=0 and bitand (ksuseflg, 1) !=0

home |  up  |  mailbox