Re: Oracle deadlock on table with indexes.

The child table has two foreign keys; one to the table where the processes are locking - this is indexed and one to another table - this is not indexed.

From your question I am guessing that this key should be indexed too?

What I find confusing is that it works fine on 8i, but not on 9i and that it is the parent table that seems to be deadlocking. Any explanation would be great, but I'll settle for an answer to my previous question!

Thanks.

Norman Dunbar <Norman_at_JUNKTHISBIT.Bountiful.Demon.co.uk> wrote in message news:<3bq5e014mfe61vdij8hbkovp3rsui8qtf6_at_4ax.com>...
> On 30 Jun 2004 02:42:48 -0700, paulz_at_cavendish.co.uk (Paul) wrote:
>
> >We are experiencing a deadlock between two processes trying to delete
> >two different rows from the same table. This table's key is a foreign
> >key in another table which is cleared before these rows are deleted.
> >
> >Both tables have their primary keys indexed and these are used for
> >deletions.
> >I enclose a copy of the oracle error log - anyone know why this is
> >happening (I do have a suspicion it may have something to do with the
> >"REPLACE", but haven't found anything to confirm this)?
>
> <BIG SNIP>
>
> you say both tables have their primary key indexed, but is the child
> table's foreign key column(s) indexed too ?
>
>
> Cheers,
> Norm.
>
>
> Remove the obvious bit to reply to my email address.
Received on Thu Jul 01 2004 - 10:35:00 CDT