Chatta subito con l'assistenza
Chat con il supporto

Spotlight on Oracle 10.6 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Redo Buffer Latches

Two latches control access to the redo buffer. The redo allocation latch must be acquired in order to allocate space within the buffer. If the redo log entry to be made is greater than the configuration parameter LOG_SMALL_ENTRY_MAX_SIZE, the session that acquires the redo allocation latch can copy the entry into the redo buffer immediately while holding the allocation latch.

If the log entry is greater than LOG_SMALL_ENTRY_MAX_SIZE, the session releases the redo allocation latch and acquires the redo copy latch in order to copy the entry.

There is only one redo allocation latch, but there may be up to LOG_SIMULTANEOUS_COPIES allocation latches.

  • If you see contention for the redo allocation latch, reduce the number of redo buffer copies that occur on this latch by decreasing LOG_SMALL_ENTRY_MAX_SIZE.
  • If you see contention for the redo copy latch, increase the number of copy latches by increasing the value of LOG_SIMULTANEOUS_COPIES.

Note: The LOG_SMALL_ENTRY_MAX_SIZE and LOG_SIMULTANEOUS_COPIES parameters were made obsolete in Oracle 8.1.

 

Related Topics

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione