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 |