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

it2022-05-05  125

某个应用正在锁定该包。

找出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#';

转载于:https://www.cnblogs.com/Elaine1133/p/5956359.html


最新回复(0)