Shared Lock - это...?

  • Article

??? ??? ???? ?????? ?? ???? ?????:

Shared Lock - ...?

?????????? ??????????? ???????????? ????????????

???? ?????

Shared Locks

Shared (S) locks allow concurrent transactions to read (SELECT) a resource under pessimistic concurrency control (see Types of Concurrency Control). No other transactions can modify the data while shared (S) locks exist on the resource. Shared (S) locks on a resource are released as soon as the read operation completes, unless the transaction isolation level is set to repeatable read or higher, or a locking hint is used to retain the shared (S) locks for the duration of the transaction.