Chat now with support
Chat with Support

Spotlight on Oracle 10.9 - 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.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating