Chatee ahora con Soporte
Chat con el soporte

Spotlight on Oracle 10.5 - 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

In Memory Undo Latch Wait Alarm

The in memory undo latch is associated with Oracle's relatively new in memory undo (IMU) structures. These structures hold in memory information formerly maintained in rollback (undo) segments. Some contention might be as a result of the new algorithm reducing redo generation and undo segment IO.

Possible remedies:

  • Increase the value of the PROCESSES parameter. This parameter indirectly controls the default number of IMU latches.
  • Turn off memory undo by adjusting the undocumented parameter: _IN_MEMORY_UNDO

Note: Oracle Corporation recommends changing undocumented parameters ONLY at the direction of Oracle Support.

 

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación