解锁卡死的存储过程

查询存储过程状态 标红为存储过程名称

SELECT * FROM V$DB_OBJECT_CACHE WHERE name='PKG_VISUALREPORT' AND LOCKS!='0';

select /*+ rule*/  SID from V$ACCESS WHERE object='PKG_VISUALREPORT';

 

查询SID

SELECT SID,SERIAL#,PADDR FROM V$SESSION WHERE SID='251';

alter system kill session '251,19785' immediate;