ORA-04021:timeout occurred while waiting to lock object package的解决办法

某个应用正在锁定该包。

找出session:

SELECT A.*, B.SID, B.USERNAME, B.MACHINE
  FROM V$ACCESS A, V$SESSION B
 WHERE A.SID = B.SID
   AND A.OBJECT = '包名'
   AND A.TYPE = 'PACKAGE';

alter system kill session 'sid,serial#';

posted @ 2016-10-13 14:21  Elaine1133  阅读(293)  评论(0编辑  收藏  举报