Re: High "in memory undo latch" waits and cpu consumption

Josh,

Oracle acquire "In memory undo latch" to access IMU structures in the memory (Shared Pool) if you are you are using "In memory Undo". Quick way to fix this issue is to turn off the In Memory Undo by setting in_memory_undo to false.

Please share the AWR or statspack report incase you want to tune this.

Thanks & Regards
-Harish Kalra

On 3/19/08, Josh Collier <Josh.Collier_at_banfield.net> wrote:
>
> An update statement that is being run with bind variables by many
> concurrent sessions is spending all its time sucking down cpu and waiting on
> "in memory undo latch".
>
> Do you guys know anything about this latch? I cannot find much about it.
>
>

--
http://www.freelists.org/webpage/oracle-l