Re: Database Buffer Cache Hit Ratio

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?
>
>

See http://www.oracledba.co.uk/tips/choose.htm

Set your BCHR to any value you wish. Received on Wed Oct 05 2005 - 14:06:07 CDT