Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Database Buffer Cache Hit Ratio
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 Received on Wed Oct 05 2005 - 10:29:53 CDT
![]() |
![]() |