立即与支持人员聊天
与支持团队交流

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

 

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级