ITPub博客

首页 > 应用开发 > IT综合 > Exclusive DDL Locks (353)

Exclusive DDL Locks (353)

原创 IT综合 作者:tsinglee 时间:2007-12-12 11:03:08 0 删除 编辑
Most DDL operations, except for those listed in the section, "Share DDL Locks" require exclusive DDL locks for a resource to prevent destructive interference with other DDL operations that might modify or reference the same schema object. For example, a DROP TABLE operation is not allowed to drop a table while an ALTER TABLE operation is adding a column to it, and vice versa. During the acquisition of an exclusive DDL lock, if another DDL lock is already held on the schema object by another operation, the acquisition waits until the older DDL lock is released and then proceeds. DDL operations also acquire DML locks (data locks) on the schema object to be modified. 排他DDL锁 1. 大多数的DDL操作需要获得排他DDL锁 , 来保护方案对象 2. 在获取DDL锁的过程中 , 如果同一方案对象上的DDL锁被获得 , 则需要等待DDL锁释放 3. 获得DDL锁的同时也获得了DML锁 vice versa : 反之亦然[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-991810/,如需转载,请注明出处,否则将追究法律责任。

上一篇: DDL Locks (352)
下一篇: Share DDL Locks (354)
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1898079