Oracle中存储过程编译卡死

--查看锁死的存储过程的SESSION_ID

SELECT * FROM DBA_DDL_LOCKS WHERE NAME =UPPER('存储过程名')

--获取

select t.sid, t.serial# from v$session t 
where t.sid in (
SELECT distinct SESSION_ID FROM DBA_DDL_LOCKS WHERE NAME =UPPER('存储过程名')
) 

--杀掉进程
--分别为SID和SERIAL#

alter system kill session 'XXX,XXX';