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';

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

解决ORA-04021:timeout occurred while waiting to lock object

ORCLE9I,编译某存储过程ORA-04021timeoutoccurred while waiting to lock object stringstringstringstringstringC...
  • xiuhaijuanqiang
  • xiuhaijuanqiang
  • 2012年02月17日 11:36
  • 4012

关于ORA-04021得解决办法(timeout occurred while waiting to lock object)

 某个应用正在锁定该表或者包表为select b.SID,b.SERIAL#,c.SQL_TEXT from v$locked_object a, v$session b, v$sqlarea c ...
  • tianyacao007
  • tianyacao007
  • 2007年03月05日 16:58
  • 8020

关于等待多长时间会引发ORA-04021: timeout occurred while waiting to lock object错误的猜测

关于等待多长时间会引发ORA-04021: timeout occurred while waiting to lock object错误的猜测...
  • msdnchina
  • msdnchina
  • 2015年06月14日 14:51
  • 1755

关于ORA-04021的解决办法(timeout occurred while waiting to lock object)

某个应用正在锁定该表或者包 表为 select b.SID,b.SERIAL#,c.SQL_TEXT from v$locked_object a, v$session b, v$sqlarea c ...
  • zihanxing
  • zihanxing
  • 2016年05月25日 09:05
  • 787

ORA-04021: timeout occurred while waiting to lock object

ORA-04021: timeout occurred while waiting to lock object
  • rgb_rgb
  • rgb_rgb
  • 2014年02月02日 11:29
  • 904

org.eclipse.jdi.TimeOutException: Timeout occurred while waiting for packet 220 occurred creating st

在使用eclipse调试(debugger)时,如果程序“吃”的资源比较多,那么就经常报如下错误: org.eclipse.jdi.TimeOutException: Timeout occurre...
  • liuxiao723846
  • liuxiao723846
  • 2017年01月08日 16:26
  • 3503

org.eclipse.jdi.TimeoutException:Timeout occurred while waiting for packet 1983.occurred

1、错误描述 2、错误原因 3、解决办法
  • you23hai45
  • you23hai45
  • 2015年05月15日 22:22
  • 6517

ORA-04020: deadlock detected while trying to lock object 报错问题解决步骤

今天客户要求迁移一个pgis的数据库到新机器上,在导入SDE用户数据的时候报:IMP-00003: ORACLE error 4020 encounteredORA-04020: deadlock d...
  • Makaveli
  • Makaveli
  • 2011年01月18日 20:16
  • 3545

oracle通过oerr快速找到相应错误代码的概述及解决方案

“ORA-XXXX”是DBA们常见的错误类型,一般情况下我们可以在网上搜索带相关解释及处理方案,如果事故现场不能上互联网,而出现的错误又未曾遇到,那我们该怎么办呢? 强大的ORACLE早已为我们考虑到...
  • u013012406
  • u013012406
  • 2016年07月12日 09:49
  • 906

ORA-04021:timeout occurred while waiting to lock object TEST.PRO_TEST

ORA-04021:timeout occurred while waiting to lock object TEST.PRO_TEST 在用sqldev重新编译存储过程时报如上错误。 解决方法...
  • u010724179
  • u010724179
  • 2013年08月14日 12:12
  • 539
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:OERR: ORA 4021 time-out occurred while waiting to lock object
举报原因:
原因补充:

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