When should you increase copy latches? What para

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

(Continued from previous question...)

When should you increase copy latches? What parameters control copy latches?

Level: high
Expected answer: When you get excessive contention for the copy latches as shown by the "redo copy" latch hit ratio. You can increase copy latches via the initialization parameter LOG_SIMULTANEOUS_COPIES to twice the number of CPUs on your system.

(Continued on next question...)

Other Job Interview Questions

• What does a Control file Contain?
• If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
• Is it possible to set a filter condition in a cross product group in matrix reports?
• Do you consider yourself a development DBA or a production DBA and why?
• Give the two types of tables involved in producing a star schema and the type of data they hold.
• What are modal windows?
• What is the proper method for disabling and re-enabling a primary key constraint?
• What are the built-ins used for finding Object ID function?
• What are the roles and user accounts created automatically with the database?
• What is the difference between boiler plat images and image items?
• More...