Tag: DB File Scattered Read

How to Tune Full Table Scan?

How to Tune Full Table Scan?

June 5, 2014 | By | Add a Comment

Eliminating DB File Scattered Reads of Oracle Wait Event In Oracle, a DB file scattered read normally indicates a full table scan. A DB file scattered read is the same type of wait event as DB file sequential read, except that Oracle is reading multiple data blocks. Depending on the setting for the DB_FILE_MULTIBLOCK_READ_COUNT parameter […]

Read More