GV$SESS_IO definition in Oracle Database 11.2
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
  ksusesor                                 -- OPTIMIZED_PHYSICAL_READS NUMBER
from
  x$ksusio
where
  bitand(ksspaflg,1)!=0 and bitand(ksuseflg,1)!=0

home |  up