V$SESS_IO definition in Oracle Database 11.2
V$SESS_IO

select
  SID,                                     -- SID NUMBER
  BLOCK_GETS,                              -- BLOCK_GETS NUMBER
  CONSISTENT_GETS,                         -- CONSISTENT_GETS NUMBER
  PHYSICAL_READS,                          -- PHYSICAL_READS NUMBER
  BLOCK_CHANGES,                           -- BLOCK_CHANGES NUMBER
  CONSISTENT_CHANGES,                      -- CONSISTENT_CHANGES NUMBER
  OPTIMIZED_PHYSICAL_READS                 -- OPTIMIZED_PHYSICAL_READS NUMBER
from
  GV$SESS_IO
where
  inst_id = USERENV('Instance')

home |  up