OERR: ORA 4021 time-out occurred while waiting to lock object
来源:互联网 发布:qq空间域名申请 编辑:程序博客网 时间:2024/05/29 17:57
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 4021 time-out occurred while waiting to lock object
- 解决ORA-04021:timeout occurred while waiting to lock object
- ORA-04021:timeout occurred while waiting to lock object ...
- ORA-04021: timeout occurred while waiting to lock object
- 关于ORA-04021得解决办法(timeout occurred while waiting to lock object)
- ORA-04021:timeout occurred while waiting to lock object TEST.PRO_TEST
- ORACLE-关于ORA-04021得解决办法(timeout occurred while waiting to lock object)
- 关于ORA-04021的解决办法(timeout occurred while waiting to lock object)
- 关于等待多长时间会引发ORA-04021: timeout occurred while waiting to lock object错误的猜测
- ORA-04020: deadlock detected while trying to lock object 报错问题解决步骤
- OERR: ORA 60 "deadlock detected while waiting for resource" [ID 18251.1](oracle deadlock 学习资料-03 死锁分析步骤)
- Oracle 9i 升级中的bug-- Sys.Cdc_alter_ctable_before ORA-04020 deadlock detected while trying to lock object
- com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource
- 关于MATLAB Error: An error occurred while shelling out to mbuild
- org.eclipse.jdi.TimeoutException:Timeout occurred while waiting for packet 1983.occurred
- org.eclipse.jdi.TimeOutException: Timeout occurred while waiting for packet 220 occurred creating st
- Lock request time out period exceeded SQL2005
- ORA-02049: timeout: distributed transaction waiting for lock
- 中断总结1
- 捕获app崩溃信息反馈给开发者
- 成 反 齊의 理
- mtd,sda,sdcard inand ,格式化和分区
- fread fwrite fseek 等总结
- OERR: ORA 4021 time-out occurred while waiting to lock object
- wikioi 1038 一元三次方程求解
- ios开发(十四)view之间的切换
- Java程序调用kettle中的job及trans
- 虚拟机设置桥接网卡
- 并查集的树实现
- ov5640,ov9712
- 【Leetcode】Two Sum
- Linux 中如何查询和卸载已安装的软件