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.

You have a system with two CPUs and the database is experiencing latch contention. Which initialization parameter can you check to find the number of redo copy latches currently assigned?

April 26, 2017contention CPU database experiencing initialization Latch parameter system

0

Posted

You have a system with two CPUs and the database is experiencing latch contention. Which initialization parameter can you check to find the number of redo copy latches currently assigned?

1 Answer

0

Posted

LOG_SIMULTANEOUS_COPIES The maximum number of redo copy latches is 2 * . This value should be used for maximum performance.