kill session

根據EYGLE的文章自己測試了下。

[@more@]

SQL> select sid,username,status
2 from v$session
3 where username is not null;

SID USERNAME STATUS
---------- ------------------------------ --------
28 SYS ACTIVE
29 READONLY INACTIVE

SQL> select 'kill -9 '||spid from v$process
2 where addr=(select paddr from v$session where sid=&did);
Enter value for did: 29
old 2: where addr=(select paddr from v$session where sid=&did)
new 2: where addr=(select paddr from v$session where sid=29)

'KILL-9'||SPID
-----------------
kill -9 16330

SQL> !
[oracle@ctdb04 u01]$ ps -eaf|grep 16330|grep -v "grep"
oracle 16330 16288 0 10:11 ? 00:00:00 oraclesouthdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
[oracle@ctdb04 u01]$ kill -9 16330
[oracle@ctdb04 u01]$ exit
exit

SQL> select sid,username,status
2 from v$session
3 where username is not null;

SID USERNAME STATUS
---------- ------------------------------ --------
28 SYS ACTIVE
29 READONLY INACTIVE

SQL> select sid,username,status,serial#
2 from v$session
3 where username is not null;

SID USERNAME STATUS SERIAL#
---------- ------------------------------ -------- ----------
28 SYS ACTIVE 37611

SQL> alter system kill session '28,37611' immediate;
alter system kill session '28,37611' immediate
*