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

Home -> Community -> Usenet -> c.d.o.misc -> Re: UPDATE fails- deadlock? -- simultaneous access to DB

Re: UPDATE fails- deadlock? -- simultaneous access to DB

From: <jstern_at_fedex.com>
Date: 22 May 2003 11:24:37 -0600
Message-ID: <3eccf9c5@ham> 





Padmashali,



Although it is possible to get deadlocks in Oracle, as in any database, 
the application should be designed to handle this condition, and either 
retry after a random time or fail the transaction and log it to a tech 
error queue of some type.  And yes access order of the tables might cause 
this issue.




Jim
Received on Thu May 22 2003 - 12:24:37 CDT












Original text of this message













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