Delete a connected user on Oracle

drop user GOAWAY cascade;
return “cannot drop a user that is currently connected”

2 solutions :

• List the session of your user :

  select username, sid, serial# from v$session where lower(username)='GOAWAY';
  alter system kill session '143, 148';

• Restart your instance :

  startup force restrict