JAVA J2EE 4 U

 SELECT 

    ROUND(AVG((bp.completion_time - bp.start_time) * 1440), 2) AS avg_full_backup_duration_mins,

    COUNT(*) AS total_full_backups,

    SYSDATE AS report_time

FROM 

    v$backup_piece bp

JOIN 

    v$backup_set bs 

    ON bp.set_stamp = bs.set_stamp AND bp.set_count = bs.set_count

WHERE 

    bs.backup_type = 'D'  -- 'D' = Full backup (datafile level)

    AND bp.status = 'A'   -- Successful backups only

    AND bp.start_time IS NOT NULL

    AND bp.completion_time IS NOT NULL

    AND bp.start_time >= SYSDATE - 30;  -- Optional: Last 30 days