Rman monitoring sql script

Here is a little something for the newer people that have just started into oracle. It's a monitoring script for rman jobs. yes, some of it came from the backup and recovery manual, but some them don't have it. It's pretty simple. Here it is.

Like I said it's simple and I'm sure a lot of the more experienced know about this. I figured I would contribute to the community. :) You might have to modify it for you db block size.

clear screen
set linesize 132
column "time started" justify center
select trunc((totalwork*8192)/1024/1024) "Total work(MB)", trunc((sofar*8192)/10
24/1024) "Work Done(MB)", to_char(start_time, 'MM-DD-YYYY HH24:MI:SS AM') "Time
started", trunc(time_remaining/60) "Time remaining(min)", round(elapsed_seconds/
60) "Time Elasped(min)", round(sofar/totalwork*100,2) "% Complete"  from v$session_longops
where opname like 'RMAN%'
and totalwork != 0
and sofar != totalwork
order by start_time, totalwork desc Received on Thu Dec 19 2002 - 09:52:41 CST