|
A shared table lock can be acquired explicitly through the use of the LOCK TABLE ... IN SHARED MODE statement. When a transaction acquires a shared table lock, that transaction can prevent changes from being made to the table until the transaction completes. Any number of transactions can hold shared table locks on the same table.