CodeDogg

select s.sid, s.serial#, s.status, p.spid

from v$session s, v$process p

where s.username = '<username>'

and p.addr (+) = s.paddr

/

alter system kill session '<session id>,<process number>';