Duration of DDL Locks (356)
-
tsinglee
2007-12-12 11:06:38
-
IT综合
-
原创
The duration of a DDL lock depends on its type. Exclusive and share DDL locks last
for the duration of DDL statement execution and automatic commit. A parse lock
persists as long as the associated SQL statement remains in the shared pool.
DDL锁的持续时间
1. 共享和排他DDL锁从DDL语句执行开始, 到自动提交结束
2. 只要相关的SQL语句还在共享池中 , 解析锁就存在[@more@]