JAVA J2EE 4 U

 SET LINESIZE 200

COL piece_handle FOR A70

COL level FOR 5

COL size_gb FOR 10

COL start_time FOR A20

COL end_time FOR A20

SELECT

    bp.handle AS piece_handle,

    bs.incremental_level AS level,

    ROUND(bp.bytes / 1024 / 1024 / 1024, 2) AS size_gb,

    TO_CHAR(bs.start_time, 'YYYY-MM-DD HH24:MI:SS') AS start_time,

    TO_CHAR(bs.completion_time, 'YYYY-MM-DD HH24:MI:SS') AS end_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.incremental_level IS NOT NULL

    AND bs.start_time > SYSDATE - 7  -- Change this to adjust date range

ORDER BY

    bs.start_time DESC;