gistfile1.txt

set colsep   " | "
alter session set nls_date_format = 'DD/MM/YYYY HH24:MI:SS';
set linesize 200 pagesize 500
col STATUS format a9
col hrs format 999.99
select
SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'dd/mm/yyyy hh24:mi') start_time,
to_char(END_TIME,'dd/mm/yyyy hh24:mi')   end_time,
elapsed_seconds/3600                   hrs,
INPUT_BYTES/1024/1024/1024 SUM_BYTES_READS_IN_GB,
OUTPUT_BYTES/1024/1024/1024 SUM_BACKUP_PIECES_WRITE_IN_GB --,INPUT_BYTES_PER_SEC_DISPLAY read_taxa_per_second,OUTPUT_BYTES_PER_SEC_DISPLAY write_taxa_per_second
from V$RMAN_BACKUP_JOB_DETAILS
where START_TIME >= sysdate -7
order by session_key desc;