Database Administrator (DBA) Question:
Download Job Interview Questions and Answers PDF
How would you go about increasing the buffer cache hit ratio?
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.
Download Database Administrator (DBA) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How would you go about generating an EXPLAIN plan? | Explain an ORA-01555 |