1.查看用户连接情况
select username,sid,serial# from v$session where username='JTCZTBH_NEW'
2.找到要删除用户的sid,和serial,并kill掉
alter system kill session'54,10707'
3.查看一下是否被删除,如果状态为killed,则被kill掉
select saddr,sid,serial#,paddr,username,status from v$session where username = 'JTCZTBH_NEW'
4.这时就可以删除用户了