JAVA J2EE 4 U

 SET LINESIZE 200

SET PAGESIZE 100

-- Script: Average Time for Incremental Backups

SELECT 

    ROUND(AVG((END_TIME - START_TIME) * 24 * 60), 2) AS AVG_INCREMENTAL_BACKUP_TIME_MINUTES,

    COUNT(*) AS TOTAL_INCREMENTAL_BACKUPS

FROM 

    V$RMAN_BACKUP_JOB_DETAILS

WHERE 

    BACKUP_TYPE = 'INCREMENTAL'

    AND STATUS = 'COMPLETED'

    AND START_TIME IS NOT NULL

    AND END_TIME IS NOT NULL;