首先查找存储过程被哪些session锁住而无法编译:
select * FROM dba_ddl_locks where name =upper('PROCEDURE_NAME');
select t.sid,t.serial# from v$session t where t.sid=&session_id;
首先查找存储过程被哪些session锁住而无法编译:
select * FROM dba_ddl_locks where name =upper('PROCEDURE_NAME');
select t.sid,t.serial# from v$session t where t.sid=&session_id;