Similar to db file sequential read, except that the session is reading multiple data blocks.
Wait Time: The wait time is the actual time it takes to do all of the I/Os
Parameter | Description |
---|---|
file# |
See "file#" |
block# |
See "block#" |
blocks |
The number of blocks that the session is trying to read from the file# starting at block# |
See Also:
Oracle Database Performance Tuning Guide for more information about this wait event
Oracle Database Performance Tuning Guide about how this wait event can help identify I/O problems
Oracle Database Performance Tuning Guide about potential causes for this wait event