Deadlock on 11g - SELECT FOR UPDATE WITH ORDER BY

From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Sat, 25 May 2013 12:28:48 -0300

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


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

Follow-Ups:
- Re: Deadlock on 11g - SELECT FOR UPDATE WITH ORDER BY
  - From: Luis

Deadlock on 11g - SELECT FOR UPDATE WITH ORDER BY

Other related posts: