Answers

Question and Answer:

  Home  Database Administrator (DBA)

⟩ 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.

 138 views

More Questions for you: