Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Your database is installed on a multi-CPU system. If the Utlbstat/Utlestat utility shows contention for the redo copy latch, which action should you take?

April 26, 2017contention database installed multi-cpu redo shows system utility utlbstat utlestat

0

Posted

Your database is installed on a multi-CPU system. If the Utlbstat/Utlestat utility shows contention for the redo copy latch, which action should you take?

1 Answer

0

Posted

Increase the value of the LOG_SIMULTANEOUS_COPIES parameter. This Parameter specifies the number of redo buffer copy latches. For Single CPU Machines set it to 0, for Multi CPU Machines set it to 2 x Number of CPUs.