Re: Help me : urgent

From: Terry Sutton <terrysutton_at_usa.net>
Date: Mon, 17 Jul 2006 16:57:49 -0700
Message-ID: <034001c6a9fc$eb524d10$45f5a8c0@TerrySutton>

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

Received on Mon Jul 17 2006 - 18:57:49 CDT