刚刚在执行存储过程时报了如下错误:
ORA-04021: timeout occrurred while waiting to lock object 用户.存储过程名称 各位大虾们帮忙分析下,有经验的同僚讲下错误原因或解决方法!
在此先谢谢了!
ORA-04021: timeout occrurred while waiting to lock object 用户.存储过程名称 各位大虾们帮忙分析下,有经验的同僚讲下错误原因或解决方法!
在此先谢谢了!
--先用这个查下
SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK',NULL)
LOCK_LEVEL,o.owner,o.object_name,o.object_type,
s.sid,s.serial#,s.terminal,s.machine,s.program,s.osuser
FROM v$session s,v$lock l,dba_objects o
WHERE l.sid = s.sid
AND l.id1 = o.object_id(+)
AND s.username is NOT NULL
---然后杀掉锁的进程
Alter system kill session 'sid,serial#'
alter system disconnect session 'sid,serial#' immediate;
ORA-04021: timeout occurred while waiting to lock object stringstringstringstringstring
Cause: While waiting to lock a library object, a timeout is occurred.
Action: Retry the operation later. 检查下,是不是相关对象被锁了?
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716