V$SESS_IO

V$SESS_IO displays I/O statistics for each user session.

Column Datatype Description
SID NUMBER Session identifier
BLOCK_GETS NUMBER Block gets for this session
CONSISTENT_GETS NUMBER Consistent gets for this session
PHYSICAL_READS NUMBER Physical reads for this session
BLOCK_CHANGES NUMBER Block changes for this session
CONSISTENT_CHANGES NUMBER Consistent changes for this session
OPTIMIZED_PHYSICAL_READS NUMBER Number of physical reads from Database Smart Flash Cache for this session