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: need help about deadlock by insert statements

Re: need help about deadlock by insert statements

From: Dariusz Trocha <trocha_at_friko5.onet.pl>
Date: Thu, 20 Aug 1998 10:10:51 +0200
Message-ID: <cRQC1.3373$ds2.1139612@news.tpnet.pl> 





User A updates some rows in table T. Then user B locks table U in exclusive
mode. Then user A tries to insert rows into U. Then user B tries to update
locked rows in T. You have deadlock and trace file shows insert statement.
Maybe this shows the reason of your problem.



Darek.



Received on Thu Aug 20 1998 - 03:10:51 CDT












Original text of this message













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