RMAN Backup Information

Script for RMAN Backup Information:

set linesize 999
col OUTPUT_BYTES_DISPLAY for a20
col TIME_TAKEN_DISPLAY for a20
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,
output_bytes_display,
time_taken_display
from v$rman_backup_job_details
order by session_key asc
/