I'm experiencing deadlocks from some embedded SQL that simply updates a row in one table. Can anyone tell me in simple english what Oracle means by deadlock. My guess is that one user or process is in the midst of a transaction that involves writting to the database, (update, insert, delete, etc...) and before that process or user finishes, another attempts to update, or otherwise "write" the same data. What level does Oracle lock it's tables? Is it at the row level, or is it at the table level? By the way, I have the virtually worthless blurb from Oracle concerning "Detecting and Resolving Deadlocks". Any info appreciated. thanks, -vince Received on Tue Aug 27 1996 - 00:00:00 CEST
Any info appreciated.
thanks, -vince
Original text of this message