---解决存储过程无法正常重建或删除，被锁定
SELECT * FROM V$DB_OBJECT_CACHE WHERE name='PROC_TRANS_TO_ZW' AND LOCKS!='0';
select /*+ rule*/ SID from V$ACCESS WHERE object='PROC_TRANS_TO_ZW';
SELECT SID,SERIAL#,PADDR FROM V$SESSION WHERE SID='1998';
alter system kill session '1998,26270' immediate ;