Database Tuning (MOSC)

MOSC Banner

Queries appear to be bypassing buffer cache

edited Sep 28, 2015 6:27PM in Database Tuning (MOSC) 7 commentsAnswered

We currently have an issue on Oracle 11.1.0.7 on Windows 2008 64bit (ASM).

It seems as though every time I run a query, the buffer cache is being bypassed and the response is being read from disk each time.

Based on the Monitored SQL Executions, for example when I run the following query:

select action#, count (*) from sys.aud$ group by action# - the 1st time I run it takes approx. 25 seconds to run.

However, subsequent runs of this take exactly the same amount of time as well as the same amount of disk IO.

Looking at the query, there are very few buffer gets and a lot of disk reads.

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