High "in memory undo latch" waits and cpu consumption

From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Tue, 18 Mar 2008 12:01:02 -0700
Message-ID: <578806DDE66A3A45916740EB73C6982AEEA8AA7AFD@M1EXCHANGE01.mmi.local>

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

Received on Tue Mar 18 2008 - 14:01:02 CDT

This message: [ Message body ]
Next message: Bradd Piontek: "Re: sync up production to UAT for a 500G+ database"
Previous message: Sweetser, Joe: "RE: Oracle DBA future"
Next in thread: Shamsudeen, Riyaj: "RE: High "in memory undo latch" waits and cpu consumption"
Reply: Shamsudeen, Riyaj: "RE: High "in memory undo latch" waits and cpu consumption"
Reply: Harish Kalra: "Re: High "in memory undo latch" waits and cpu consumption"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message