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/