qq_25983417的博客

找出占用资源的会话，并删除 1：找出所有被锁的对象，定位出哪个回话占用select l.session_id,o.owner,o.object_namefrom v$locked_object l,dba_objects owhere l.object_id=o.object_id结果：session_id owner object_name

可用SYS登录，然后查询如下语句：查找存储过程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