Backup hangs

Some times , rman sessions can hang due to so many reasons, or some time we may have to stop

the backup jobs, during those times we can use the below query to grab oracle rman session details to 

kill from the database level 

COLUMN CLIENT_INFO FORMAT a30

COLUMN SID FORMAT 999

COLUMN SPID FORMAT 9999

SELECT s.SID, p.SPID, s.CLIENT_INFO
FROM   V$PROCESS p, V$SESSION s
WHERE  p.ADDR = s.PADDR
AND    CLIENT_INFO LIKE 'rman%'
/