RE: deadlock trace file in weblogic environment

<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       

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Thu Feb 12 2009 - 12:30:18 CST