RE: High "in memory undo latch" waits and cpu consumption
Date: Tue, 18 Mar 2008 14:45:50 -0500
What version of Oracle? Can you please print output of following SQL?
select * from v$latch_misses where parent_name like 'In%memory%undo%'
You may be hitting bug 5751672, not sure though..
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Josh Collier Sent: Tuesday, March 18, 2008 2:01 PM
Subject: High "in memory undo latch" waits and cpu consumption
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.Received on Tue Mar 18 2008 - 14:45:50 CDT