终止oracle正在执行的存储过程

kevinlee0755

--查看运行的procedure (表提供对象在library cache(shared pool) 中对象统计--package package body--kept 是否常驻shared pool,依赖于对象是否利用pl/sql过程--locks 锁定对象的session数--pins 执行对象的 session数--loads 自初始被加载次数select * from v$db_object_cache where type='PROCEDURE' and locks>0 and pins>0;--终止procedure select * from v$access a where object like 'SETEMUSERCONTEXT%'select * from v$session where sid in(135,157,138,141)alter system kill session '136,635' --'sid,serial#'