Answers

Question and Answer:

  Home  Oracle Database

⟩ What Is a Data Lock in Oracle?

A data lock is logical flag the Oracle server is placed on data objects to give an exclusive right to a transaction. Statements in other transactions needs to respect data locks based on certain rules. Rules on data locks are:

► SELECT query statements do not create any data locks.

► INSERT, UPDATE, and DELETE statements create data locks on the affected rows.

► Data locks are released when the owner transaction ends.

 149 views

More Questions for you: