#For Non-RAC
select 'alter system kill session ''' ||sid ||','||serial#||''' immediate;' from v$session where blocking_session is not null order by sid;

#For RAC
select 'alter system kill session ''' ||sid ||','||serial#||',@'||inst_id ||''' immediate;' from gv$session where blocking_session is not null order by sid,inst_id;