1：查询数据库连接
select username,sid,serial# from v$session where username like ‘%BIZ_XNJD_ZC%‘;
2杀掉进程
alter system kill session ‘229,5123‘ ;
3 查询连接是否别killed
select saddr,sid,serial#,paddr,username,status from v$session where username is not null and username like ‘%BIZ_XNJD_ZC%‘;
删除所有的连接即可删除用户
4删除用户
drop user biz_xnjd_zc cascade;
原文：http://www.cnblogs.com/devin818/p/6064378.html