Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "Prevent" ora-60 deadlocks: impossible OK ?
On Mon, 09 May 2005 10:19:08 +0200, Matthias Hoys wrote:
>
> Try to proove that there are faults in the design of the application.
And there must be some. Deadlocks are circular waits, not to be confused with hangs and endless waits, and can be prevented by always locking in the same order. In other words, if one transaction is updating table A and then table B, then all transactions which need to update those two tables must update table A first and then table B. If there is a transaction first updating table B and then table A, there is a possibility of a deadlock. In my opinion, anybody using such terminology as w*ers should be fired on the spot. Self control and anger management are virtues.
-- Demagogue: One who preaches a doctrine he knows to be untrue to men he knows to be idiots. H.L. MenckenReceived on Mon May 09 2005 - 05:40:22 CDT