What Is a Data Lock?
Page 1 of 1
What Is a Data Lock?
by Micheal Sun Jan 17, 2010 3:39 am
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
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
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» How To Experiment a Data Lock?
» What is lock escalation?
» What Is a Dead Lock?
» What Happens If You Lost a Data File?
» How Data Locks Are Respected?
» What is lock escalation?
» What Is a Dead Lock?
» What Happens If You Lost a Data File?
» How Data Locks Are Respected?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Accessing tables of other users in SQL
» Grouping commands in SQL
» Operations on Result Sets in SQL
» Subqueries in SQL
» Joining Relations in SQL
» Delete comand in SQL
» Update command in SQL
» Insert command in SQL