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

Josh

            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..  

Thanks

Riyaj               

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Josh Collier Sent: Tuesday, March 18, 2008 2:01 PM
To: oracle-l_at_freelists.org
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.  

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