SQL> 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>
1、SELECT 'ALTER SYSTEM KILL SESSION '||SID||','||SERIAL# FROM V$SESSION
WHERE username is not null AND status='ACTIVE';
2、SQLPLUS中执行上句的结果。
改一下:
SELECT 'ALTER SYSTEM KILL SESSION '''||SID||','||SERIAL#||''';' FROM V$SESSION
WHERE username is not null AND status='ACTIVE';