we have a database with the Cache hit ratio 27%,
what can i do?
RDBMS version 220.127.116.11.1
Platform : Sun Solaris 2.6
What kind of cache, data cache, library cache, or dictionary
If it's Buffer cache hit ratio, then increase the size of the buffer cache.
data/buffer cache - increase db_block_buffers
library cache or dictionary cache - increase shared_pool
"I pledge to stop eating sharks fin soup and will not do so under any circumstances."
the buffer cache hit ratio is 27%, i increase de db_block_buffers but the cache hit ratio down, i check parameters of init and db_block_lru_latches = 1, do you thing that i increase lru latches help to performance
did you bounce the database after you modified the parameter? You have to