Monday, March 25, 2013

Oracle: Skip locked rows

In Oracle 11g you can

SELECT *
FROM EMPLOYEES
FOR UPDATE SKIP LOCKED;

Which means that you'll get rows that are not locked by another session.
Posted by Unknown at 8:59 AM
Labels: ,

1 comment:

  1. UnknownOctober 15, 2013 at 6:21 AM

    Further read: http://rwijk.blogspot.ro/2007/12/parallellism-in-skip-locked-scenario.html

    ReplyDelete

Subscribe to: Post Comments (Atom)