oracle 杀死指定用户的session

---杀死指定会话的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'

转载于:https://blog.51cto.com/ocpyang/1194468