OERR: ORA 4021 time-out occurred while waiting to lock object

原创 2013年12月05日 21:53:07

Purpose
Provide OERR information for ORA-4021.

Details
Error:  ORA 4021
Text:   time-out occurred while waiting to lock object <name>
-------------------------------------------------------------------------------
Cause:  While trying to lock a library object, a time-out occurred.
Action: Retry the operation later.

Explanation:
This is locking error where Oracle uses a piece of memory which is shareable among all the database users calling the Library Cache. This  maintains information about objects such as pl/sql packages, views, tables, etc.The object cannot be change while in used.  In order to modify the object, there is a lock in the library cache.  A session will wait on the library cache as the object is in use.  Until the lock is released, the error ora-4021 error.
Diagnosis:
Retry the process as the lock may be released.  Or kill the process holding the lock.   Check V$ACCESS for users of the object:

SELECT SID, OWNER, OBJECT, TYPE
              FROM V$ACCESS
              WHERE OBJECT = 'object_name';

版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

OERR: ORA 1652 unable to extend temp segment by %s in tablespace %s [ID 19047.1]

修改时间:2012-7-25类型:REFERENCE状态:PUBLISHED优先级:3 注释 (0) ...

OERR: ORA-8103 "object no longer exists" Master Note / Troubleshooting, Diagnostic and Solution (Doc

In this Document   Purpose   Scope   Details   D...

版本压缩(Compress)提示"ORA-00060: deadlock detected while waiting for resource".

当我们对版本数据进行Compress操作时,可能会碰到Oracle的错误:"ORA-00060: deadlock detected while waiting for resource". ...

运行 openfire4.04 ServerStarter 报异常 AdminConsolePlugin:192 - An exception occurred while trying to mak

AdminConsolePlugin:192 - An exception occurred while trying to make available the admin console via ...

Eclipse安装WindowBuilder提示错误:An error occurred while collecting items to be installed,解决方法

Eclipse安装WindowBuilder提示错误,具体信息如下所示: An error occurred while collecting items to be installed sess...
  • ZXH0717
  • ZXH0717
  • 2014年09月24日 00:10
  • 4848

hibernate 的many to one 的问题IllegalArgumentException occurred while calling setter of hibernatePOJO

package com.oyth.model; public class Book { private int BookID; private String BookName; pri...

Java输出导致死锁,at java.io.PrintStream.println(PrintStream.java:805) - waiting to lock <0x0000000494fa83

Java输出导致死锁,at java.io.PrintStream.println(PrintStream.java:805) - waiting to lock (a java.io.Pri...

MessagingTimeout: Timed out waiting for a reply to message ID

l3中出现大量消息超时错误,对网络的操作各种异常。 报错如下: 2016-02-25 05:54:59.886 15110 ERROR neutron.agent.l3.agent [req-db...

iOS开发 报错process launch failed: timed out waiting for app to launch的解决方案

今天我在发布一个新的版本之后一直报错process launch failed: timed out waiting for app to launch,现象是在真机测试的时候 软件安装后弹出这条信息...

Oracle RAC 第二节点 root.sh 报错 Timed out waiting for the CRS stack to start

在VBox 上安装11.2.0.1的RAC。 这里打算安装11.2.0.1是因为从11.2.0.2以后的版本对public 和private 网卡网段区分很严格,这个网卡必须配置在不同的网段。 而在1...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:OERR: ORA 4021 time-out occurred while waiting to lock object
举报原因:
原因补充:

(最多只允许输入30个字)