MONITOREAR TIEMPO DE BACKUPS RMAN

set serveroutput on

set linesize 150

set pagesize 300

col time_taken_display for a9

select session_key,

input_type,

status,

to_char(start_time,'yyyy-mm-dd hh24:mi') start_time,

to_char(end_time,'yyyy-mm-dd hh24:mi') end_time,

time_taken_display

from v$rman_backup_job_details

order by session_key desc;