RMAN Backup job details

posted Sep 13, 2010, 7:27 AM by Sachchida Ojha
SELECT to_char(start_time,'mm/dd/yyyy hh:mi:ss') as start_time,to_char(end_time,'mm/dd/yyyy hh:mi:ss') as end_time, status, session_key FROM v$rman_backup_job_details order by end_time desc;

Other useful colums

, session_recid, session_stamp, command_id,  time_taken_display, input_type,
 output_device_type, input_bytes_display, output_bytes_display, output_bytes_per_sec_display
 
Comments