RE: deadlock trace file in weblogic environment

From: Barun, Vlado <Vlado.Barun_at_JTV.com>
Date: Thu, 12 Feb 2009 13:30:18 -0500
Message-ID: <0181A069127F1944B484ED5B858D0C160C0EA9C0BD_at_KPMSPW02.jewelry.acn>



The wait-for-graph columns are:

<BLOCKED|BLOCKER> <lockp> <cvt|held mode> <res name> <did|pid|txn_id> <node>

Regards,
 
Vlado Barun, M.Sc.
Sr. Manager, Database Engineering and Operations Jewelry Television
Mobile: 865 335 7652
Email: vlado.barun_at_jtv.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of hrishy Sent: Friday, January 30, 2009 7:23 AM
To: oracle-l_at_freelists.org
Subject: deadlock trace file in weblogic environment

Hi

I am trying to troubleshoot a deadlock issue in oracle10g RAC environment using weblogic server.

I tried searching metalink but did not receive any hits for a document that can explain me how to troubleshoot a dealock issue when using weblogic.

There are 100's of messages in the alert log saying a deadlock occured but there is only one trace file why is this ? The trace files gets appended with the error messages for the dead lock.

I am attaching the sample trace file anybody knows how i can interpret the trace file.

regards
Hrishy       

i0zX+n{+i^ Received on Thu Feb 12 2009 - 12:30:18 CST

Original text of this message