ORA-01940: cannot drop a user that is currently connected

SQL> drop user stat_fine cascade;
drop user stat_fine cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

锁定用户：

alter user STAT_FINE account lock;

通过v$session视图查找连接这个用户的session

select sid,serial#,username,status,MACHINE from v$session where username='STAT_FINE';

kill掉使用该用户连接的session：

alter system kill session '&sid,&serial#';