_gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(ga); })();

Increasing the buffer cache hit ratio

On June 19, 2009 / By admin / In Oracle / Reply

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:

  1. Hit ratio What is hit ratio ?   It is a...
  2. Tuning indicators What tuning indicators can one use?   The following...
  3. Dictionary cache What is dictionary cache ? Dictionary cache is information...
  4. Dictionary cache What is dictionary cache ? Dictionary cache is information...
  5. 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.

Reply

Spam Protection by WP-SpamFree