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

Home -> Community -> Usenet -> c.d.o.server -> Re: Database Buffer Cache Hit Ratio

Re: Database Buffer Cache Hit Ratio

From: Bart the bear <bartthebear_at_gmail.com>
Date: 5 Oct 2005 12:12:02 -0700
Message-ID: <1128539522.416095.152470@z14g2000cwz.googlegroups.com>

pcambraf wrote:
> Hi people.
>
> I had an 8.1.7.4 database with a 68% of buffer hit ratio and 180 Mb of
> cache, I've changed the db_block_buffers parameter so we have 234 Mb of
> db buffer cache, and the hit ratio is now 57%, almost a 10% less!!.
> I'm mad about this, i've been looking around and i think it could be a
> I/O retention in the only one DBWR process, żis this possible?
>
> Are there any other factors to consider?
>
> Thank you so much...
>
> Regards

Have you ever considered changing profession? Working on something palpable,
actually producing something by your own two hands, and possibly a hammer?
You could even be a supreme court judge, absolutely no experience is necessary
for the position. Responsibility of being a DBA might be a bit too much for
you. You'd be an ideal NYC cabbie. Received on Wed Oct 05 2005 - 14:12:02 CDT

Original text of this message

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