Re: Oracle deadlock on table with indexes.

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 Wed Jun 30 2004 - 11:26:04 CDT