Re: Ora 04020 - deadlock detected while trying to lock object

From: Alan Formstone <aformstone_at_us.lhsgroup.com>
Date: Mon, 25 Oct 1999 17:28:37 -0400
Message-ID: <3814cbb0@news.lhsgroup.com>

Thomas Kyte wrote in message ...
>
>are you using declaritive integrity? do you have your foreign keys
indexed?
>See the URL in my signature for a short paper "Unindexed Foreign Keys --
why
>they might be bad and how to detect them"

>See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to
Oracle8i'...
>Current article is "Part I of V, Autonomous Transactions" updated June
21'st
>
>

All the foriegn Keys are indexed, a point i didn't mention earlier is that the failing statement is an insert.
Also there are no triggers on this table.

Thanks,
Alan Received on Mon Oct 25 1999 - 16:28:37 CDT