It returns the most recently committed version of the rows, even if another concurrent session holds an exclusive row-level lock.
即使另一个并发会话持有一个独占式行级锁,它仍然返回最近提交的行。
During an export operation, row-level locking is applied to the exporting table, which means that only one lock is held at a time.
在导出操作期间,行级别锁定应用于导出表(exportingtable),这意味着一次只持有一个锁。
Some databases (such as SQL Server) allow you to disable the page-level locking in hopes that it won't escalate from a row-level lock to a table-level lock.
一些数据库(比如sqlServer)允许您禁用页面级锁,以期它不会从行级锁切换到表级锁。
These locks could be table level, row level, or lock on index, and so on.
这些锁可以是表级锁、行级锁、索引锁等等。
Tables created by Informix default to page-level locking, so when two or more users attempt to update a row on the same page, at least one will get a lock error.
Informix创建的表默认执行了页面级锁定,所以当两个或更多用户尝试更新同一页面中的一行时,至少一个用户将获得锁定错误。
These next key locks are only obtained when the key INSERT finds that a scanner with a Repeatable Read (RR) isolation level has a row lock on the next-higher key in the index.
这些nextkey锁只有在keyINSERT发现带有RepeatableRead (RR)隔离级别的扫描器在索引中的next -higher键上有一个行锁时才能获得。
So we can see 3 active locks: exclusive lock on key (row) level and 2 intent-exclusive locks on the page and table levels.
我们看到了3个锁信息,一个排它锁在行记录上,两个意向排它锁在页级以及数据表对象上。
So we can see 3 active locks: exclusive lock on key (row) level and 2 intent-exclusive locks on the page and table levels.
我们看到了3个锁信息,一个排它锁在行记录上,两个意向排它锁在页级以及数据表对象上。
应用推荐