Rman backup set pages 2000 lines 200 COL STATUS FORMAT a9 COL hrs FORMAT 999.99 select INPUT_TYPE, STATUS, TO_CHAR(START_TIME,'mm/dd/yy hh24:mi') start_time, TO_CHAR(END_TIME,'mm/dd/yy hh24:mi') end_time, ELAPSED_SECONDS/3600 hrs, INPUT_BYTES/1024/1024/1024 SUM_BYTES_BACKED_IN_GB, OUTPUT_BYTES/1024/1024/1024 SUM_BACKUP_PIECES_IN_GB, OUTPUT_DEVICE_TYPE FROM V$RMAN_BACKUP_JOB_DETAILS order by SESSION_KEY;