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;
SELECT * FROM V$SESSION WHERE TYPE='USER';
原文链接：https://www.f2er.com/oracle/209669.html