What Is a Dead Lock?
Page 1 of 1
What Is a Dead Lock?
by Micheal Sun Jan 17, 2010 3:42 am
A dead lock is phenomenon happens between two transactions with each of them holding a lock
that blocks the other transaction as shown in the following diagram:
(transaction 1) (transaction 2)
update row X to create lock 1
update row Y to create lock 2
update row X
(blocked by lock 1)
update row Y
(blocked by lock 2)
(dead lock created)
that blocks the other transaction as shown in the following diagram:
(transaction 1) (transaction 2)
update row X to create lock 1
update row Y to create lock 2
update row X
(blocked by lock 1)
update row Y
(blocked by lock 2)
(dead lock created)
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» What is lock escalation?
» What Is a Data Lock?
» How To Experiment a Data Lock?
» How Oracle Handles Dead Locks?
» What Is a Data Lock?
» How To Experiment a Data Lock?
» How Oracle Handles Dead Locks?
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