ORACLE-- Highest Time taken to Manage Full and Incremental Backup

select rownum as rank
       ,name
       , DECODE(backup_type,'D','Full','I','Incremental'
           ,'L','Archive Log',backup_type) backup_type
       ,round(max_secs/60) mins
FROM ( select name , backup_type , max(elapsed_seconds)  max_secs
     from rc_backup_set bs, rc_database d
     where bs.db_key = d.db_key
     group by name, backup_type
     order by max(elapsed_seconds) desc
     )
WHERE rownum <= 10
order by backup_type;

Note: This is the highest time taken to complete a full and incremental backup. it is not the
average time to accomplish the backup. The highest time for a backup can be any reason for a particular
day backup. Always consider the average time for a backup.