oracle killsession

一条语句结束oracle的多个会话

 

select 'alter system kill session '||''''||sid||','||serial#||''''||';' from v$session where username='ASSET';

 

 

'ALTERSYSTEMKILLSESSION'||''''
--------------------------------------------------------------------------------
alter system kill session '139,15';
alter system kill session '140,12';
alter system kill session '143,481';
alter system kill session '145,20';
alter system kill session '147,1225';
alter system kill session '149,840';
alter system kill session '152,1428';
alter system kill session '158,127';
alter system kill session '159,660';

9 rows selected