Select For Update Skip Locked

  • Norbert Debes


SELECT FOR UPDATE SKIP LOCKED is undocumented in Oracle9i and Oracle10g. It is used behind the scenes by Advanced Queuing, a reliable messaging service built into the ORACLE DBMS. Oracle11g Release 1 is the first DBMS release that includes documentation on SELECT FOR UPDATE SKIP LOCKED. The SKIP LOCKED clause improves the scalability of applications that attempt to concurrently update the same set of rows in a table. It eliminates wait time for TX locks. Consistency and isolation are preserved. The DBMS server assigns a fair share of the rows to each database client that is interested in an overlapping result set.


These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Norbert Debes 2009

Authors and Affiliations

  • Norbert Debes

There are no affiliations available

Personalised recommendations