oracle查看用户连接及kil连接

p

1. 查看当前数据库所有用户连接

select username,sid,serial# from v$session;

2. 查看某个Active用户连接的sid和serial#
select username,sid,serial#,status from v$session
where username='aaa' and status='ACTIVE';
3. kill某个用户连接

alter system kill session ‘sid,serial#’;
alter system kill session ‘154,12354’;