Increasing the buffer cache hit ratio
How would you go about increasing the buffer cache hit ratio?
Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set db_cache_size command.
Related posts:
- Hit ratio What is hit ratio ? It is a...
- Tuning indicators What tuning indicators can one use? The following...
- Dictionary cache What is dictionary cache ? Dictionary cache is information...
- Dictionary cache What is dictionary cache ? Dictionary cache is information...
- Three advisory statistics you can collect Name three advisory statistics you can collect. Buffer...
Related posts brought to you by Yet Another Related Posts Plugin.