Database Tuning (MOSC)

MOSC Banner

Buffer hit ratio calculate

edited Oct 28, 2019 11:47AM in Database Tuning (MOSC) 4 commentsAnswered

Hi,

DB version : 11.2.0.4

select * from v$sysstat where name in ('physical reads','db block gets','consistent gets')

SYS@epssuat> select * from v$sysstat where name in ('physical reads','db block gets','consistent gets','db block gets from cache','consistent gets from cache','physical reads cache');

STATISTIC# NAME                                                                  CLASS                VALUE    STAT_ID

---------- ---------------------------------------------------------------- ---------- -------------------- ----------

        84 db block gets                                                             8            143325887 1480709069

        85 db block gets from cache                                                  8            139319837 4017839461

        88 consistent gets                                                           8          31555837774 4162191256

        89 consistent gets from cache                                                8          30556039057 2839918855

        94 physical reads                                                            8           1193453432 2263124246

        95 physical reads cache                                                      8            102455070 4171507801

May i know which one is correct calculate for Buffer cache hit ratio % ? what is diff ?

1 - (('physical reads cache') / ('consistent gets from cache' +

'db block gets from cache')

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