sql> DROP USER test CASCADE;
DROP USER test CASCADE
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

我按照SO中的链接找出了会话 – Dropping a connected user from an Oracle 10g database schema

但是当我运行命令时，我没有得到任何结果：

sql> select sid,serial# from v$session where username = 'test';

no rows selected

请帮助我在这种情况下如何删除用户。