-
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
Jeff Hunter
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|