Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Is there any harm in setting very large db_cache_size even when buffer hit ration does not increase?
I have sevel GB's of memory on my HP UNIX server. My buffer hit ration is
low (50%). I have increased db_cache_size (Oracle9i) gradually. I have not
seen increase in hit ration all that much. My question, is there any harm
in increasing db_block_size so it uses 1Gb or more of memory (which is avaiable
to Oracle database instance) without causing any impact on other applications
on that sever. Actaully, my server is mainly a database oracle server. There
are a few application scripts which run in the night for a few minutes.
I would think more memory I use by increasing db_cache_size will help the performance even if hit ratio is not increasing all that much (i.e. it is 55% instead of 95%.
Prem Received on Thu May 20 2004 - 20:39:21 CDT
![]() |
![]() |