exclusive table lock 中文意思是什麼
exclusive table lock
解釋
履行這種大的事務所產生的獨占鎖-
Are escalated to an exclusive lock on the table, and all other lower - granularity locks, including intent locks, on
上持有的所有鎖都將被升級到該表上的排他鎖，而 -
Setting an intent lock at the table level prevents another transaction from subsequently acquiring an exclusive lock on the table containing that page
在表級設置意向鎖可防止另一個事務隨后在包含那一頁的表上獲取排他鎖（ x鎖） 。 -
For example, before a sql server database engine task applies shared or exclusive row locks within a table, it places an intent lock on the table
其他用戶可以同時讀取數據，但在釋放所有共享鎖之前，任何事務都不能獲取對該數據的排他鎖。 -
Specifies that an exclusive lock is taken on the table
指定表採用排他鎖。 -
To escalate locks, the database engine attempts to change the intent lock on the table to the corresponding full lock, for example, changing an intent exclusive lock to an exclusive lock, or an intent shared lock to a shared lock
升級鎖時，數據庫引擎將嘗試將表上的意向鎖更改為對應的全鎖，例如，將意向排他鎖（ ix鎖）更改為排他鎖（ x鎖） ，或將意向共享鎖（ is鎖）更改為共享鎖（ s鎖） 。
分享友人