Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Interpretting a deadlock trace file
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]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)-------- =0001-0017-00000002
---------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 =
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
![]() |
![]() |