(On UNIX) When should more than one DB writer pr

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

(Continued from previous question...)

(On UNIX) When should more than one DB writer process be used? How many should be used?

Level: High
Expected answer: If the UNIX system being used is capable of asynchronous IO then only one is required, if the system is not capable of asynchronous IO then up to twice the number of disks used by Oracle number of DB writers should be specified by use of the db_writers initialization parameter.

(Continued on next question...)

Other Job Interview Questions

• What is a Redo Log?
• You have just compiled a PL/SQL package but got errors, how would you view the errors?
• When creating a user, what permissions must you grant to allow them to connect to the database?
• What are some indications that you need to increase the SHARED_POOL_SIZE parameter?
• What is a database link?
• Explain iostat, vmstat and netstat.
• What are the default extensions of the files created by menu module?
• What are the values that can be specified for OPTIMIZER MODE Parameter?
• Use the Add_group_row procedure to add a row to a static record group 1. true or false?
• If you see the value for reloads is high in the estat library cache report is this a matter for concern?
• More...