Re: Need help debugging ORA-00060: DEADLOCK

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 20 Oct 1999 23:56:31 +0100
Message-ID: <940462101.22718.1.nnrp-10.9e984b29@news.demon.co.uk>

What does the trace file say ?

One possibility is that you need to increase INITRANS on the key table. (Probably means a rebuild). If there is only room left for one transaction per block, you could get:

process A grabs ITL slot on block 1, then goes for ITL slot on block 2 process B grabs ITL slot on block 2, then goes for ITL slot on block 1

This is really only likely to happen if you have managed to pack your datablocks extremely tightly though.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

rgutterman_at_my-deja.com wrote in message <7ugk20$f9u$1_at_nnrp1.deja.com>...
>I'm having a problem with an Oracle 8i deadlock condition.
>I have two processes executing the same SQL code - so they should be
>updating tables in the same order. They also should not need to access
>the same rows. But I get the error ORA-00060: deadlock detected while
>waiting for resource. Anything other than locking tables in a
>different order which could cause this problem? Any suggestions how I
>can pin it down?
>TIA
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Oct 20 1999 - 17:56:31 CDT