What are shared locks?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are shared locks?
Rating:
Shared locks are used for locking objects so that only users belonging to the workspace of an object are able to modify it. This lock is also placed on the parent version of the object to avoid conflicts arising for the object. Shared locks are comparatively less restrictive than exclusive locks. The advantage of shared locks over exclusive locks is that by using the former type of locks, users of the workspace that holds the shared lock can access the locked object.
Rating:
Was this information helpful?
Other articles
- What does a Log File Switch Completion event indicate?
- What are locks?
- What is UNRECOVERABLE keyword?
- What is the REBUILD option of the ALTER INDEX statement?
- What is alert log?