Verifica Estatisticas de Backup RMAN

set lines 200 pagesize 200
set timing on
col STATUS format a10
col tempo format a10
col INPUT_TYPE for a15
col OPTIMIZED for a10
col tam_backup for a10
col inicio for a20
col final for a20
select *
from (select INPUT_TYPE
        ,STATUS
        ,to_char(START_TIME,'DD/MM/yy hh24:mi') as INICIO
        ,to_char(END_TIME,'DD/MM/yy hh24:mi') as FINAL
        ,TIME_TAKEN_DISPLAY tempo
        ,OPTIMIZED
        ,d.OUTPUT_BYTES_DISPLAY tam_backup
    from V$RMAN_BACKUP_JOB_DETAILS d
    where START_TIME > sysdate-30
    order by session_key desc)
where rownum <=30;