oracle 会话查询和删除

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

select username,account_status from dba_users;

select username,sid,serial# from v$session where username = 'username';