-- =======================================================================
--  Using the V$SESSION and V$SESSION_WAIT_HISTORY Views 
--  to Troubleshoot RMAN Problems.
-- =======================================================================
Select 
	sid, serial#, event, seconds_in_wait
From v$session
Where sid in (select sid from v$session Where program like '%rman%');

	SID SERIAL# EVENT 							SECONDS_IN_WAIT
-------	-------	------------------------------ 	---------------
	121 	269 RMAN backup & recovery I/O 					  2
	129 	415 SQL*Net message from client 				 63
	130 	270 SQL*Net message from client 				  8


Select 
	sid, event, wait_time
From v$session_wait_history
Where sid in (select sid from v$session	Where program like '%rman%')
And wait_time>0;

SID EVENT 						 WAIT_TIME
--- --------------------------- ----------
121 RMAN backup & recovery I/O 			11
129 SQL*Net message from client 		 1
129 SQL*Net message from client 		 2
129 SQL*Net message from client 		 2
130 SQL*Net message from client 	   400
130 SQL*Net message from client  	   200
130 SQL*Net message from client 	   100
130 SQL*Net message from client 	   766