RE: Drop Foreign Key and Insert causing deadlock

From: Jonathan Lewis <>
Date: Tue, 25 Feb 2014 19:20:29 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901DDFF72_at_exmbx05.thus.corp>

Have you raised an SR and passed your demonstration - it's probably worth doing.

Why do you have to drop the constraint rather than disabling it ? Have you tried a cycle of "alter ... rely disable novalidate" / "alter ... enable novalidate" / "alter ... validate" When the ORA-00060 happens what type of locks are deadlocking ? Is the graph always the same ?

Have you considered simply not setting ddl timeouts and using a loop with a short dbms_sleep() to capture any locking errors and and retry after (say) 1/100the second ?

Jonathan Lewis

From: [] on behalf of Vasu [] Sent: 25 February 2014 18:50
To: Mark W. Farnham
Subject: Re: Drop Foreign Key and Insert causing deadlock

I have got ORA-04020, ORA-00060 (and also ORA-00054 which is timeout as expected).

Rest of the reply inline .

Received on Tue Feb 25 2014 - 20:20:29 CET

Original text of this message