确认存储过程是否死锁
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.