---杀死指定会话的session
select 'alter system kill session ||sid,||','serial#||,username from v$session where username='JINRILOG';
alter system kill session '36,1683';
---批量KILL指定用户所有session
select 'alter system kill session '''|| sid ||''||','|| serial# ||''';' from v$session where username='JINRILOG'
select 'alter system kill session ||sid,||','serial#||,username from v$session where username='JINRILOG';
alter system kill session '36,1683';
---批量KILL指定用户所有session
select 'alter system kill session '''|| sid ||''||','|| serial# ||''';' from v$session where username='JINRILOG'