These locks could be table level, row level, or lock on index, and so on.
这些锁可以是表级锁、行级锁、索引锁等等。
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),这意味着一次只持有一个锁。
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创建的表默认执行了页面级锁定,所以当两个或更多用户尝试更新同一页面中的一行时,至少一个用户将获得锁定错误。
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)允许您禁用页面级锁,以期它不会从行级锁切换到表级锁。
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个锁信息,一个排它锁在行记录上,两个意向排它锁在页级以及数据表对象上。
应用推荐