db file scattered read
The db file scattered read wait event has three parameters: file#, first block#, and block count. In Oracle Database 10g, this wait event falls under the User I/O wait class. Keep the following key thoughts in mind when dealing with the db file scattered read wait event.
The Oracle session has requested and is waiting for multiple contiguous database blocks (up to DB_FILE_MULTIBLOCK_READ_COUNT) to be read into the SGA from disk.
Multiblock I/O requests are associated with full table scans and index fast full scans (FFS) operations. ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
