Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Buffer cache hit very low...!!!

Re: Buffer cache hit very low...!!!

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 13 Sep 2005 13:54:24 -0700
Message-ID: <bf4638050913135443f30c6b@mail.gmail.com>


On 9/13/05, Chirag DBA <chiragdba_at_gmail.com> wrote:
>
> Did someone mean that RATIOS are absolete now and those should not be
> considered now.

They are not *completely* useless, but they do not tell you much.

Some ratios are less useless than others - this is just about the DBCHR.

If your DBCHR (database cache hit ratio) is unusually low, it tells you that something may be different.

Or it may just mean you've never seen it that low because you observed it at the wrong time.

Or it may mean nothing at all.

The DBCHR does not give you any idea what on your database needs to be corrected, or even *if* anything needs corrected.

This is more of an advanced topic. You need to learn how Oracle works before delving into this.

If your users are happy, don't worry about fixing things that probably are not broken. :)

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
11+ years of trying to appear to know what I'm doing.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 13 2005 - 15:56:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US