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')