Home » Interview » Technology

How would you go about increasing the buffer cache hit ratio?

Correct Answer: 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

← Previous Question Next Question→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion