How would you go about increasing the buffer cache hit ratio?
ORACLE Interview Questions and Answers (Part 5)
(Continued from previous question...)
746. 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.
(Continued on next question...)
Other Interview Questions