查殺 oracle sql 卡死的進程

標籤：

--查出SID名字
select * from v$access where object =‘PKG_SMSSEND_PROC‘;
--通過sid查出spid
select  spid,osuser, s.program  from v$session s,v$process p where s.paddr=p.addr and s.sid=(select sid from v$access where object =‘PKG_SMSSEND_PROC‘);
--殺進程
登入ssh， kill -9 spid

select spid,osuser
  from v$session s, v$process p
 where s.paddr = p.addr
   and s.sid in (select sid from v$access where object = ‘PKG_SMSSEND_PROC‘);
PKG名字要大寫
   
   
   
   --第二種
   [ 查看鎖 ]
select a.object_name||‘|‘||b.session_id||‘|‘||c.serial#||‘|‘||c.program||‘|‘||c.username||‘|‘||c.command||‘|‘||c.machine||‘|‘||
c.lockwait from all_objects a,v$locked_object b,v$session c where a.object_id=b.object_id and c.sid=b.session_id;

[ 解鎖 ]
alter system kill session ‘session_id,serial‘

查殺 oracle sql 卡死的進程