Delete or Update Running Slow with 'db file scattered read waits' on Index Range Scan
Last updated on SEPTEMBER 29, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
- SQL is running slow, and the 10046 event trace shows wait on "db file scattered read" and "db file scattered read" is on an index.
- The execution plan indicates the table is getting accessed by "index range scan", and there is no indication of full scan on either on the table or the index. The waits on the index range scan on the index should be shown an "db file sequential reads"
- The number of blocks fetched during "db file scattered read" is 11 which is different than the db_file_multiblock_read_count parameter
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms