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 -> UPDATE fails- deadlock? -- simultaneous access to DB

UPDATE fails- deadlock? -- simultaneous access to DB

From: Padmashali <g_padmashali_at_yahoo.com>
Date: 6 May 2003 17:27:53 -0700
Message-ID: <3ebd7b0d.0305061627.4e776aac@posting.google.com> 





We are facing the DB dead-lock problem. Multiple Access to tables are
required. More than one transactions are trying to access the same
table and DB deadlock is noticed.



Will the order of access the Tables will resolve the problem, if I
provide controlled access to each table in a particular order.



Request you all to suggest various methodology/approach to prevent
such scenario.



Its Very Urgent.



Thank You Very Much



Best Regards


Padmashali
Received on Tue May 06 2003 - 19:27:53 CDT












Original text of this message













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