Re: Help me : urgent

From: Andrey Kriushin <Andrey.Kriushin@xxxxxxxx>
To: terrysutton@xxxxxxx
Date: Thu, 20 Jul 2006 15:46:27 +0400

Just to remind

event 10027 level 1 could be used to mitigate the impact of ORA-60 processing

-- Andrey

Terry Sutton пишет:

Cold, hard experience.

Bug 2530125  Hang possible with "enqueue hash chains" latch held during
deadlock detection

Or, as described to me by Oracle Support about 3 years ago, "Deadlock
detection dumps the processstate while holding the 'parent+children enqueue
hash chains' latch which can cause the blocking symptoms you describe while
the processtate is dumped. "

Supposedly fixed in 9.2.0.7 and 10.1.0.2.  I don't believe Sachin mentioned
what version he was on.

holding a latch and doing file I/O ? Where did you get that idea?


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

References:

RE: Help me : urgent
From: Kevin Closson

Re: Help me : urgent
From: Terry Sutton

Re: Help me : urgent

Other related posts: