oracle的用户session

删除一个用户，报错，删除的用户正在连接中。

SQL> drop  user user_test cascade;

drop user user_test cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that iscurrently connected

 

查看一下该用户的session状态

SQL> select username,sid,serial#,status from v$session where username='USER_TEST';

USERNAME   SID  SERIAL#  STATUS
---------- ---- ------- --------
USER_TEST  136  15565    INACTIVE

Kill该用户(用SID SERIAL#)

SQL> alter system kill session '136,15565';

System altered.

 

再次删除，成功

SQL> drop  user user_test cascade;

User dropped.