QUESTION 26 OF 30

When should copy latches be increased, and what parameters are used to do this?

By asking the question in this manner, the interviewer has made several assumptions. First, they assume you know what a copy latch is. They also assume that you know when these should be increased. Finally, they hope to confirm that you know the parameters used to accomplish this. While this is a multipart question, its primary purpose is to explore your knowledge and capabilities related to Oracle database tuning.

You can answer this question by first stating what you look for to confirm that the copy latches need to be increased. The next step is to describe how you would do this. Make sure to include the format of the initialization parameter you would use to address this issue. As with any technical question, you should be prepared for follow-up with the interviewer will use to explore this issue in more depth.

"When you see a 'redo copy' in latch hit ratio, you know there is excessive contention for the copy latches. To fix this, you can increase copy latches. This is done by invoking the initialization parameter LOG_SIMULTANEOUS_COPIES to increase the copy latches to twice the number of CPUs available in the system."

Unlock all 30 Oracle Performance Tuning questions

Unlock expert responses to complex tuning scenarios that database architects evaluate.

Get Started

Previous Question Next Question

Oracle Performance Tuning Mock Interview

When should copy latches be increased, and what parameters are used to do this?

Unlock all 30 Oracle Performance Tuning questions

30 Oracle Performance Tuning Interview Questions & Answers