Home » Unlabelled » How would you go about increasing the buffer cache hit ratio? | Oracle 10g Interview Questions
Friday, 2 November 2012
How would you go about increasing the buffer cache hit ratio? | Oracle 10g Interview Questions
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 comments:
Post a Comment