Re: ORA-00060: deadlock detected while waiting for resource

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 8 Jun 2005 07:18:53 -0700
Message-ID: <1118240332.978564.95690@f14g2000cwb.googlegroups.com>

Deadlock information like that shown where one of the sessions has no row are not unusual and I do not think an iTAR is necessary or will do much good. The problem is still the application where two different sessions are going after the same data.

Session 7 holds a row (TM) and needs information from the rollback segment (TX) held exclusively by session 52.

Question what does "Session 7: obj - rowid = 0000B5E8 - AAALXoABFAAAAHWAAC" point to?

To solve the problem it is necessary to find the two pieces of code and compare what they do, in what order they do it, and consideration has to be given to the rows that the Oracle read consistency model will be returning recognizing the fact a second session will be accessing some of the same rows during the transaction.

HTH -- Mark D Powell -- Received on Wed Jun 08 2005 - 09:18:53 CDT