Re: Deadlock resolution

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 19 Feb 2004 13:47:12 -0600
Message-ID: <ud68asvld.fsf@standardandpoors.com>

On Thu, 19 Feb 2004, gooiditweg_at_sybrandb.demon.nl wrote:
> On 19 Feb 2004 11:12:17 -0600, Galen Boyer
> <galenboyer_at_hotpop.com> wrote:
>

>>The hard thing is that Oracle doesn't tell you what objects
>>were involved in the deadlock, and it can be anything.

>
> I don't think this is true. Ora-060 will always result in a
> trace file with detailed info about open cursors, lockmodes
> etc.

Hm... Sets up a deadlock situation... Looks at trace file.

I'll be damned. I solved an insidious deadlocking issue a few weeks ago and didn't use that info. How many times do I have to tell myself, just look at the trace file you dummy!

-- 
Galen Boyer

Received on Thu Feb 19 2004 - 13:47:12 CST