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

Home -> Community -> Usenet -> c.d.o.server -> Re: Deadlock resolution

Re: Deadlock resolution

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 19 Feb 2004 20:22:13 +0100
Message-ID: <q53a305pmbj48474onpemms9jl3h55p0bm@4ax.com> 





On 19 Feb 2004 11:12:17 -0600, Galen Boyer <galenboyer_at_hotpop.com>
wrote:



>The hard thing is that Oracle doesn't tell you what objects were

>involved in the deadlock, and it can be anything.




I don't think this is true. Ora-060 will always result in a trace file
with detailed info about open cursors, lockmodes etc.



--
Sybrand Bakker, Senior Oracle DBA


Received on Thu Feb 19 2004 - 13:22:13 CST












Original text of this message













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