Database Administrator (DBA) Question:

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

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

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 QuestionNext Question
How would you go about generating an EXPLAIN plan?Explain an ORA-01555