SELECT SID, SERIAL#, MACHINE, USERNAME FROM V$SESSION WHERE USERNAME='TOBREMOVEDUSER' ;

alter system kill session 'SID,SERIAL';

DROP USER TOBREMOVEDUSER CASCADE;