Dead Lock [message #182899] |
Tue, 18 July 2006 11:27 |
manish mendiratta
Messages: 110 Registered: May 2002
|
Senior Member |
|
|
Hi Guys,
I have been about deadlock and some where i read ...
"Application developers can eliminate all risk of enqueue deadlocks by ensuring that transactions requiring multiple resources always lock them in the same order."
Now what does it means by "lock them in same order"?
Please explain
thanks
M
|
|
|
|
|
Re: Dead Lock [message #182926 is a reply to message #182919] |
Tue, 18 July 2006 13:58 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
The FAQ shows how you get a deadlock if session1 locks table emp then dept; and session2 locks dept then emp.
To solve this problem, update in the same order. For example, session1: emp then dept; session2: emp then dept.
|
|
|