Database Tuning (MOSC)

MOSC Banner

Buffer Cache Hit.

edited Jun 13, 2018 10:09AM in Database Tuning (MOSC) 18 commentsAnswered
Hi,
On may 07, I have run query about Buffer :
SQL> select round(((1-(sum(decode(name,
2 'physical reads', value,0))/
3 (sum(decode(name, 'db block gets', value,0))+
4 (sum(decode(name, 'consistent gets', value, 0))))))*100),2)
5 || '%' "Buffer Cache Hit Ratio"
6 from v$sysstat;

Buffer Cache Hit Ratio
-----------------------------------------
83.72%

This month, the user complain about JDE slow.. I check that in the application server is fine (JDE), then I rebuild index for some table and the user statisfied.

But Yesterday, I check buffer again, and this is the result :
SQL> select round(((1-(sum(decode(name,
2 'physical reads', value,0))/
3 (sum(decode(name, 'db block gets', value,0))+

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