Data Warehousing Community Forum
February 09, 2012, 12:08:27 am

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Differnce b/n Shared and Exclusive Locks?  (Read 1624 times)
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« on: June 20, 2007, 05:45:34 pm »
Differnce between Shared and Exclusive Locks?

Shared Lock - A Shared lock is one that permits other users to query the data on the tables, but not allows to change it.

I think Exclusive lock also defines the same.

Please let me know what's the exact difference between those?

Is there any "Shared Exclusive Lock" also?
Logged
Sipra
Founder

www.dwforum.net
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 on: June 21, 2007, 06:29:12 pm »
Hi,

There's a lot of differnece between Shared Lock and Exclusive Lock.
As you explained Shared lock is Correct. An Exclusive lock can be defined as follows:

Exclusive Lock - An Exclusive Lock is one that permits the other users to Query data, but not to change it.

It differs from Shared lock because it doesnot permit the user to place any type of lock on the same data; several users may place share locks on the same data at the same time.

Coming to Shared Exclusive Lock, I have heard about it. but no knowledge. Let give me some time to find it.
Logged
If most people said what’s on their minds, they’d be speechless.
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: