set lines 200
col username for a15
col osuser for a12
col machine for a22
col program for a22
col ospid for a10
col status for a10
col event for a31
col module for a30
col block_ss for a10
alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss';
define_editor=vi;
select 'alter system kill session ''' || s.sid || ',' || s.serial# || ''' immediate;' from gv$session s, gv$process p where s.paddr = p.addr and s.module like '%backup%' order by logon_time;