--–注意PROCESS是相同，即为同一个进程

SQL> select spid from v$process whereaddr=' 0000000091895250';

SPID

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

21287

想要KILL这个会话，可以如下操作：

SQL> alter system kill session '51,252';

alter system kill session '51,252'

*

ERROR at line 1:

ORA-00031: session marked for kill

可能会出现如上的错误，这虽然能终止该会话，但是不能释放相关资源。

SQL> alter system kill session '51,252'immediate;

System altered.

SQL> selectsid,serial#,server,paddr,process from v$session where username='SCOTT';

SID SERIAL# SERVER PADDR PROCESS

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

21 536 DEDICATED 0000000091892190 19652

Kill一个进程只需要执行如下操作：

SQL> selectsid,serial#,server,paddr,process from v$session where username='SCOTT';

SID SERIAL# SERVER PADDR PROCESS

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

21 536 DEDICATED 0000000091892190 19652

27 1094 DEDICATED 000000009188D050 21629

?

SQL> select spid from v$process whereaddr='000000009188D050';

SPID

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

21632

SQL> ho kill -9 21632

SQL> select sid,serial#,server,paddr,process from v$session whereusername='SCOTT';

SID SERIAL# SERVER PADDR PROCESS

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

21 536 DEDICATED 0000000091892190 19652

27 1094 DEDICATED 000000009188D050 21629

虽然进程被kill了，但是没有退出去，还是能查到，退出之后就查不到了。

http://docs.oracle.com/cd/E11882_01/server.112/e40540/process.htm#CNCPT9840