查找存儲過程OPERATIONDATA_IMP(存儲過程名)被哪些session鎖住而無法編譯
select * FROM dba_ddl_locks where name =upper('OPERATIONDATA_IMP');
進而得到session_id,然後通過
select t.sid,t.serial# from v$session t
where t.sid=&session_id;
得到sid和serial#
最後用alter system kill session 'sid,serial#'; kill 相關session即可。