11g Locking Enhancements (Doc ID 464512.1)
适用
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.6 [Release 11.1] Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Information in this document applies to any platform. Information in this document applies to any platform.
目的
本文描述了Oracle Database 11gR1引入的与Locking相关的新特性:
序列化锁
明确的locking table
共享锁
范围
DBA有兴趣了解与 11g 中引入的锁定相关的新特性。
细节
序列化锁
Oracle Database 11g中允许DDL命令等待DML锁,你可以通过在系统或会话级别设置 DDL_LOCK_TIMEOUT 参数来限制 DDL 命令等待 DML 锁的时间,该初始化参数默认设置为零,即:nowait,保证向后兼容。
值的范围是0-1000000(以秒为单位)&#