Database Tuning (MOSC)

MOSC Banner

Very low DB Buffer cache hit ratio, how to improve it?

Hi all, I'm a total beginner when comes to performance tuning the DB. Recently my company just implemented a third party monitoring software to monitor all our hardware & software. I notice on my Oracle DB there's an alert thrown, the alert is referring to the DB Buffer cache hit ratio. The recommended value should be 99% but it's currently at 41%.

I then ran the below script on the DB directly.

SELECT ROUND((1-(phy.value / (cur.value + con.value)))*100,2) "Cache Hit Ratio"
FROM v$sysstat cur,
    v$sysstat con,
    v$sysstat phy
WHERE cur.name = 'db block gets'
AND con.name = 'consistent gets'
AND phy.name = 'physical 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