myorama
12/15/2015 - 4:39 PM

rman job details.sql

set lines 120
set pages 300
alter session set NLS_DATE_FORMAT="DD/MM/YYYY-HH24:MI:SS";
select start_time "Start", round(input_bytes/1024/1024*10)/10 "Source MB", 
       round(output_bytes/1024/1024*10)/10 "Backup MB", input_type "Type", status "Status",
       round(elapsed_seconds/60*10)/10 "Duration (min)", round(COMPRESSION_RATIO*10)/10 "Ratio" 
  from v$rman_backup_job_details 
 where start_time >= SYSDATE-10 order by 1 desc;