1 查出用户的session:
SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME='epdm';
2 杀掉用户epdm的session:
ALTER SYSTEM KILL SESSION 'SID,SERIAL#';
3 删掉用户epdm
DROP USER EPDM CASCADE;
ps:如何查看当前登录数据库的用户:
SELECT * FROM V$SESSION WHERE TYPE='USER';