SELECT sum(work_done_percnt)/count(work_done_percnt) from(
	SELECT 	sl.sid, context, sofar, totalwork,client_info,
                    round(sofar/totalwork*100,2) work_done_percnt
     	FROM 	v$session_longops sl, v$session s
     	WHERE 	opname LIKE 'RMAN%'
     	AND 	opname NOT LIKE '%aggregate%'
     	AND 	sl.sid=s.sid
     	AND 	totalwork != 0
     	AND 	sofar <> totalwork);

SELECT 	sid, spid, client_info,status 
       	FROM 	v$process p, v$session s 
       	WHERE 	p.addr = s.paddr 
        AND 	client_info LIKE '%rman channel%';