Oracle杀掉会话或process

2014-11-24 18:30:45 · 作者: · 浏览: 1

一:


SQL> SELECT pid,spid FROM V$PROCESS WHERE ADDR IN (SELECT PADDR FROM V$SESSION where username ='SYS');


PID SPID


---------- ------------


17 13657


ps -ef |grep 13657


kill -9 13657


二:


SQL> SELECT sid,serial# FROM V$SESSION WHERE sid in (SELECT distinct sid FROM V$MYSTAT);


SID SERIAL#


---------- ----------


1637 13894


alter system disconnect session '1637,13894' immediate;