ORACLE 查看用户会话,强制结束,并删除用户.

查看当前用户的会话.

select sid, serial#, username, program from v$session where username = 'HOGE';

       SID    SERIAL# USERNAME   PROGRAM                  
---------- ---------- ---------- -------------------------
       xxx        yyy HOGE       ample@DB

结束一个会话.

alter system kill session 'SID, SERIAL';

消除用户.

DROP USER user [CASCADE];