Shared Lock (S):- No write locks can be requested for this objects. Several users can view the data. Several users can give shared lock on the same object.
Exclusive Lock (E):- This is not user specific. Its transaction specific. Only one transaction given by the user who provided the lock can again lock the object being locked in E mode. Also the lock can be removed only by the person who locked it.
Exclusive but cumulative (X):- This lock can be called only once. Furthur lock creations are rejected even thogh using the same transaction. Also called as write lock
Award points if helpful
Regards,
Shyam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.