Database Buffer Cache Hit Ratio

Giganews Newsgroups
Subject: Database Buffer Cache Hit Ratio
Posted by:  pcambraf (pedro.camb…@gmail.com)
Date: 5 Oct 2005

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, =BFis this possible?

Are there any other factors to consider?

Thank you so much...

Regards

Replies