we have a database with the Cache hit ratio 27%,
what can i do?
RDBMS version 7.3.4.0.1
Platform : Sun Solaris 2.6
Printable View
we have a database with the Cache hit ratio 27%,
what can i do?
RDBMS version 7.3.4.0.1
Platform : Sun Solaris 2.6
What kind of cache, data cache, library cache, or dictionary
cache?
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
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