是否可以更改Oracle的默认对象锁定超时? [英] Can Oracle's default object lock timeout be changed?
问题描述
> ALTER PACKAGE blah COMPILE;
(wait about 10 minutes)
> ORA-04021: timeout occurred while waiting to lock object
我了解为什么会收到超时错误(该软件包正在使用中).
I understand why I get the timeout error (the package is in use).
有人知道是否可以更改默认的10分钟等待间隔吗?可以在数据库/会话/语句级别配置它吗?
Does anyone know if there's a way to change the default 10 minute wait interval? Can this be configured at a database / session / statement level?
谢谢
推荐答案
there is a DDL_LOCK_TIMEOUT
parameter since 11gR1 :
DDL_LOCK_TIMEOUT
指定DDL语句在DML锁定队列中等待多长时间的时间限制.默认值为零,表示状态为NOWAIT
.最大值1,000,000秒将导致DDL语句永远等待获取DML锁.
DDL_LOCK_TIMEOUT
specifies a time limit for how long DDL statements will wait in a DML lock queue. The default value of zero indicates a status ofNOWAIT
. The maximum value of 1,000,000 seconds will result in the DDL statement waiting forever to acquire a DML lock.
我不确定您是否可以更改以前版本中的默认超时.
I'm not sure you can change the default timeout in the previous releases.
这篇关于是否可以更改Oracle的默认对象锁定超时?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!