oracle无法删除当前连接用户方法

(1)查看用户的连接状况 

select username,sid,serial# from v$session 

------------------------------------------ 

如下结果： 



username          sid                serial# 

---------------------------------------- 

NETBNEW          513              22974 
NETBNEW          514              18183 
NETBNEW          516              21573 
NETBNEW          531              9 
WUZHQ             532              4562 

(2)找到要删除用户的sid,和serial，并删除 

------------------------------------------- 

如：你要删除用户'WUZHQ',可以这样做： 



alter system kill session'532,4562' 



(3)删除用户 

-------------------------------------------- 

drop user username cascade