The session waits while a sequential read from the database is performed. This event is also used for rebuilding the control file, dumping data file headers, and getting the database file headers.
Wait Time: The wait time is the actual time it takes to do the I/O
| Parameter | Description |
|---|---|
|
file# |
See "file#" |
|
block# |
See "block#" |
|
blocks |
This is the number of blocks that the session is trying to read (should be 1) |
See Also:
Oracle Database Performance Tuning Guide for more information about this wait event
Oracle Database Performance Tuning Guide for more information about how this wait event can help identify I/O problems
Oracle Database Performance Tuning Guide about potential causes for this wait event