Articles on deadlock ?

[Mockenrue]

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 ID354.144) 2001.04.17.09.16.54.000
DEADLOCK 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:



----------------------------------------------------------------------------
<<

 

[alexhu]

Search on this one for deadlock

http://asktom.oracle.com

Alex

 

[Mockenrue]

Thanks Alex.