搜出该用户的session的SID,SERIAL码,然后kill掉
select sid,serial# from v$session where username='user_name';
select sid,serial# from v$session where username='user_name';
alter system kill session 'sid,serial';
alter system kill session '527,2832';