JAVA J2EE 4 U

 SELECT 

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

    COUNT(*) AS total_full_backups,

    SYSDATE AS report_generated_at

FROM 

    v$backup_set

WHERE 

    backup_type = 'D'  -- Only full backups

    AND status = 'A'   -- Only successful

    AND start_time IS NOT NULL

    AND completion_time IS NOT NULL

    AND start_time >= SYSDATE - 30;  -- Adjust window as needed