DBA > Job Interview Questions > DATABASE Administrator (DBA) Interview Questions and Answers

How would you go about increasing the buffer cac

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

23. 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 Job Interview Questions