Dropping connected users in Oracle database

April 6, 2023 by Tarik

Users are all capitals in v$session (and data dictionary views). If you match with capitals you should find your session to kill.

SELECT s.sid, s.serial#, s.status, p.spid 
  FROM v$session s, v$process p 
 WHERE s.username="TEST" --<<<--
  AND p.addr(+) = s.paddr
 /

Pass actual SID and SERIAL# values for user TEST then drop user…:

ALTER SYSTEM KILL SESSION '<SID>, <SERIAL>'
/