Database Tuning (MOSC)

MOSC Banner

Index Unique and Range scan showing db file scattered reads - is it index prefetch

edited Mar 25, 2010 2:48AM in Database Tuning (MOSC) 10 commentsAnswered
While reviewing the results of a ADDM report, it shows 2 queries with a lot of potential to improve. However when we look at those queries, the associated wait events and plan of those queries, it shows an index unique scan and an index range scan -which is as it should be. However one of the top wait events is "db file scattered read". It was surprising to see multi block reads with an index unique/range scan! It seems that for the initial period of the test, these multi block reads result in lesser throughput. Infact on the x86 platform, after

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center