Deadlock on 11g - SELECT FOR UPDATE WITH ORDER BY

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sat, 25 May 2013 12:28:48 -0300
Message-ID: <CAJdDhaMsev=hs8HvevnX701Li2=h7+XdqqB6ta2ONJXcR4hp6A_at_mail.gmail.com>

Hi,
There is a code that run on 10g sucessfully. After migration to 11g started getting ORA-00060 (Deadlock).

Then looking for solutions, people got it this link:

http://orasql.org/2013/02/16/workaround-for-deadlock-with-select-for-update-order-by-on-11-2-0-2-11-2-0-3/

Any experience with this kind of problem and solution ? Did you applied workaround like this and solved problems related to SELECT FOR UPDATE WITH ORDER BY ? I guess that the sample works fines ( I did not test it).

Regards
Eriovaldo

--
http://www.freelists.org/webpage/oracle-l

Received on Sat May 25 2013 - 17:28:48 CEST