| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
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 |