确认存储过程是否死锁

SELECT * FROM V$DB_OBJECT_CACHE WHERE name='PKG_TEST' AND LOCKS!='0';

查出sid的值

select SID from V$ACCESS WHERE object='PKG_TEST';

查sid,serial#

SELECT SID,SERIAL#,PADDR FROM V$SESSION WHERE SID='刚才查到的SID';

kill正在使用的session

alter system kill session 'sid值,serial#值' immediate;

Q.E.D.