Kill Session

select 'alter system kill session '||''''||sid||','||serial#||''';'
from (select SID,s.SERIAL# from v$session s,v$process p,v$transaction t
where s.osuser is not null and
s.username = upper('&username') and
s.status =upper('&status') and
-- and logon_time < (sysdate-15/1440)
s.paddr = p.addr and
s.taddr = t.addr (+));