Script for monitoring RMAN progress: Using the following SQL you can monitor the progress of RMAN process, as channels completes creating the backup piece, new sessions are created so overall progress can be monitored by looking at where context = 3 as in the case below it shows the overall progress is 38.05% complete. SELECT SID, SERIAL#, USERNAME, START_TIME, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR / TOTALWORK * 100, 2) "%_COMPLETE", sysdate + TIME_REMAINING / 3600 / 24 Entimated_End_Time FROM V$SESSION_LONGOPS WHERE OPNAME LIKE ' RMAN% ' AND OPNAME NOT LIKE ' %aggregate% ' AND TOTALWORK != 0 AND SOFAR <> TOTALWORK ; Related Link: Related Link on This Topic RMAN Performance Tuning