select s.sid, s.serial#, s.status, p.spid from v$session s, v$process p where upper(s.username) = upper('USERNAME') and p.addr (+) = s.paddr; alter system kill session '<s.sid>,<s.serial#>';