--–注意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