Oracle杀掉会话或process

Oracle杀掉会话或process

一:

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;

相关推荐