某个应用正在锁定该包。
找出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#';
某个应用正在锁定该包。
找出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