ORCLE9I,编译某存储过程
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.
查找是否有用户类型的锁,即
TM DML排队
TX 事务处理排队
UL 用户提供
select * from v$lock where type in ('TM','TX','UL')
结果果然查到有一个sid为17,类型为TX的锁,可以断定就是这个锁导致上面的错误
再查相应的sid和serial#
select * from v$session where sid=17
杀掉它
alter system kill session '17,36383'
ORA-00031: session marked for kill ,说明已经是被kill一次过的了,session的status为killed
再查操作系统对应的SPID
select spid from v$process p,v$session s where s.paddr=p.addr and sid=17
查到是17297
$ kill -9 17297
重新编译,成功了
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14075938/viewspace-509700/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14075938/viewspace-509700/