Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
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 flash cache for this session |