Kill Session

select s.sid,s.serial#, s.status,p.spid
from v$session s,v$process p
where s.username='USER_NAME'
and p.addr(+)=s.paddr;

alter system kill session '<sid>,<serial#>';