DDL Locks (352)

A data dictionary lock (DDL) protects the definition of a schema object while that

object is acted upon or referred to by an ongoing DDL operation. Recall that a DDL

statement implicitly commits its transaction. For example, assume that a user creates a

procedure. On behalf of the user’s single-statement transaction, Oracle automatically

acquires DDL locks for all schema objects referenced in the procedure definition. The

DDL locks prevent objects referenced in the procedure from being altered or dropped

before the procedure compilation is complete.

Oracle acquires a dictionary lock automatically on behalf of any DDL transaction

requiring it. Users cannot explicitly request DDL locks. Only individual schema objects

that are modified or referenced are locked during DDL operations. The whole data

dictionary is never locked.

DDL locks fall into three categories: exclusive DDL locks, share DDL locks, and

breakable parse locks.

DDL锁(数据字典锁)

1. DDL锁的作用是在执行 DDL 操作时对被修改的方案对象或其引用对象的定义进行保护

2. 当用户创建一个存储过程时 , Oracle自动获取过程中定义的对象的DDL锁

3. 用户不能显示获取数据字典锁

4. DDL锁分为以下三类 : 排他DDL锁, 共享DDL锁 , 可解除的解析锁

[@more@]

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

转载于:http://blog.itpub.net/10599713/viewspace-991808/