Peter, That's a good start, but there are few other clues to look for in the = trace file. 1.) What statement caught the deadlock? This info will be in the trace = file. 2.) Are you on 9i? If so, the SQL of all the other statements involved = in the deadlock will also be in the trace file. 3.) Look for a section called "Rows waited on:" This will give you the = object id, file#,block#,slot# of the row(s) involved in the deadlock. Hope that helps, -Mark -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Schauss, Peter Sent: Friday, August 27, 2004 3:07 PM To: Oracle-L (E-mail) Subject: Interpretting a deadlock trace file I returned from vacation to find a trace file,=20 the result of a deadlock detected in one of our applictions, in my udump directory. It contained the text of one of the offending SQL statements, followed by what it called a "Deadlock graph" Deadlock graph: ---------Blocker(s)-------- = ---------Waiter(s)--------- Resource Name process session holds waits process session = holds waits TX-0003002a-0000a0c8 23 70 X 17 119 = X TX-00020028-0000a1b5 17 119 X 23 70 = X session 70: DID 0001-0017-00000002 session 119: DID = 0001-0011-00000002 session 119: DID 0001-0011-00000002 session 70: DID = 0001-0017-00000002 Looking at this it seems that session 70 was holding a resource = identified by TX-0003002a-0000a0c8 and waiting on TX-00020028-0000a1b5 and that session 119 was doing the oposite. How do I translate these values to actual database objects (i.e. table names, indexes, ...)? Thanks, Peter Schauss ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------