Does anyone know some good articles on deadlocks (not wait locks) in Oracle
on the web ?
DBA frequently reports listings like this:
>>
*** 2003.04.17.09.16.54.000
*** SESSION ID
354.144) 2001.04.17.09.16.54.000DEADLOCK DETECTED
Current SQL statement for this session:
UPDATE ...
----- PL/SQL Call Stack -----
object line object
handle number name
91065120 1674 package body APPS. ...
91065120 1537 package body APPS. ...
91023ce8 9 package body APPS. ...
85419d60 15 APPS. ...
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
----------------------------------------------------------------------------
<<