先查询出要kill的sessionSQL> select username,status,sid,serial# from v$session where username is not null;USERNAME STATUS SID SERIAL#
------------------------------ -------- --------- ---------
SYS ACTIVE 11 38493SQL> /USERNAME STATUS SID SERIAL#
------------------------------ -------- --------- ---------
TEMP INACTIVE 9 38038
SYS ACTIVE 11 38493SQL> alter system kill session '9,38038';系统已更改。SQL> select username,status,sid,serial# from v$session where username is not null;USERNAME STATUS SID SERIAL#
------------------------------ -------- --------- ---------
TEMP KILLED 9 38038
SYS ACTIVE 11 38493SQL>
------------------------------ -------- --------- ---------
SYS ACTIVE 11 38493SQL> /USERNAME STATUS SID SERIAL#
------------------------------ -------- --------- ---------
TEMP INACTIVE 9 38038
SYS ACTIVE 11 38493SQL> alter system kill session '9,38038';系统已更改。SQL> select username,status,sid,serial# from v$session where username is not null;USERNAME STATUS SID SERIAL#
------------------------------ -------- --------- ---------
TEMP KILLED 9 38038
SYS ACTIVE 11 38493SQL>
begin
alter system......
...
end;
/
吧祝8以上可以
10:55:52 SQL> begin
10:55:58 2 execute immediate 'alter system kill session ''11,3031''';
10:56:05 3 end;
10:56:08 4 /PL/SQL 过程已成功完成。实际:761
10:56:09 SQL> select username,status,sid,serial# from v$session where username is not null;USERNAME STATUS SID SERIAL#
------------------------------ -------- --------- ---------
TEMP KILLED 11 3031
SYS ACTIVE 13 26804实际:30
10:56:17 SQL>
杀进程是DBA在必要的时候做的事情
不是小孩子拿来玩的~~~~~~~~~