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