A value used to determine the level of concurrency that the lock provides:
S – Shared lock in serializable isolation.
Sn – Shared lock in non-serializable isolation
U – Update lock in serializable isolation.
Un – Update lock in non-serializable isolation.
En – End-of-scan lock for non-serializable isolation.
IRC – Intention shared lock in non-serializable isolation.
IS – Intention shared lock in serializable isolation
IU – Intention update lock in serializable isolation
IUn – Intention update lock in non-serializable isolationIX – Intention exclusive lock in serializable isolation
IXn – Intention exclusive lock non-serializable isolation
SIX – Shared lock with intent to set an exclusive lock in serializable isolation.
SIXn – Shared lock with intent to set an exclusive lock non-serializable isolation.
X – Exclusive lock.
Xn – Exclusive lock in non-serializable isolation.
W – Update, insert or delete table lock.
XNi – Next lock for inserting into tables or non-unique index
NS – Table lock in read-committed isolation that conflicts with all table locks in serializable isolationLock "0" means the blocker is still in the waiting list.
TimesTen Lock
最新推荐文章于 2023-01-29 14:39:45 发布
TimesTen In-Memory Database Reference