What Is Lock Granularity?

1.	What Is Lock Granularity?
Answer» There are many locks AVAILABLE for the database system to have likeIntent SHARED, Shared, INTENT exclusive, exclusive and Shared Intent exclusive. Locking granularity refers to the size and hence the number of locks USED to ensure the consistency of a database during multiple concurrent updates. There are many locks available for the database system to have likeIntent Shared, Shared, Intent exclusive, exclusive and Shared Intent exclusive. Locking granularity refers to the size and hence the number of locks used to ensure the consistency of a database during multiple concurrent updates.

Answer»

There are many locks AVAILABLE for the database system to have likeIntent SHARED, Shared, INTENT exclusive, exclusive and Shared Intent exclusive.

Locking granularity refers to the size and hence the number of locks USED to ensure the consistency of a database during multiple concurrent updates.

There are many locks available for the database system to have likeIntent Shared, Shared, Intent exclusive, exclusive and Shared Intent exclusive.

Locking granularity refers to the size and hence the number of locks used to ensure the consistency of a database during multiple concurrent updates.

Discussion