The hang is caused by an exclusive row lock on table EMPLOYEE.
挂起是由表 EMPLOYEE上一个独占式的行锁导致的。
This means that an exclusive lock is always placed on the indexed table while a functional index is being created or dropped.
这说明，在创建或删除函数索引时，执行索引的表中始终持有一个排他锁。
The load utility accomplishes this by requesting a super exclusive (Z) lock on the table and retaining this lock for the duration of the load operation (see Listing 4).
load工具实现这一点的方法是，请求目标表上的一个超级排他（Z）锁，并在加载操作期间一直持有这个锁（参阅清单4）。
The import utility accomplishes this by requesting an exclusive (X) lock on the table at the beginning of an ALLOW NO ACCESS import operation.
import工具实现这一点的方法是在ALLOWNOACCESS导入操作的开始请求目标表上的一个排他（X）锁。
When you use the ONLINE keyword, DDL operations execute without applying an exclusive lock to the table on which the specified index is defined.
在使用ONLINE关键字时，DDL操作是在没有将排它锁应用于定义特定索引表的情况下执行的。
Its primary deficiency is that it takes an exclusive lock on the table.
主要的缺陷是它对表实施了独占锁。
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个锁信息，一个排它锁在行记录上，两个意向排它锁在页级以及数据表对象上。
应用推荐