Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Interpretting a deadlock trace file

RE: Interpretting a deadlock trace file

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 27 Aug 2004 16:59:34 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF09660D97@bosmail00.bos.il.pqe>


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)--------  =

---------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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Aug 27 2004 - 16:18:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US