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.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Reply

Spam Protection by WP-SpamFree