0 Replies - 1835 Views - Last Post: 30 July 2013 - 06:25 PM

#1 janaki  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 22
  • Joined: 11-April 08

requested lock, waits, or deadlocks

Posted 30 July 2013 - 06:25 PM

Suppose that S1, S2, and S3 are sessions connected concurrently to the same database instance. Suppose further that D1, D2, and D3 are data objects that can be locked with a shared and exclusive lock

Q) S1 has an exclusive lock on D1 and is waiting for an exclusive lock on D2. S2 has an exclusive lock on D2 and is waiting for an exclusive lock on D1.

A) This could leads to dead lock because D1 is an exclusive lock and is waiting for D2

Q)S1 has an exclusive lock on D1 and is waiting for an exclusive lock on D2. S2 has an exclusive lock on D2 and is waiting for an exclusive lock on D3. S3 has an exclusive lock on D3 and is waiting for an exclusive lock on D1.

A) This is also another example for a dead lock

Please help me if I am right or wrong....

Is This A Good Question/Topic? 0
  • +

Page 1 of 1