set lines 300
set pages 30
select 'alter system kill session '''||s.sid||','||s.serial#||''''||'; '
FROM V$SESSION_WAIT sw, V$SESSION s, V$PROCESS p
WHERE s.client_info LIKE 'rman%'
AND s.SID=sw.SID
AND s.PADDR=p.ADDR;