Generate redo data

select *
 from (SELECT to_char(min(begin_interval_time), 'DD-Mon-YY HH24:MI') ||' - ' ||
               to_char(max(begin_interval_time), 'DD-Mon-YY HH24:MI') as WHEN,
              dhso.object_name,
              dhso.object_type,
              dhso.tablespace_name,
              sum(db_block_changes_delta) as db_block_changes,
              to_char(round((RATIO_TO_REPORT(sum(db_block_changes_delta)) OVER())
                             * 100, 2), '99.00')||' %' as REDO_PERCENT          
         FROM dba_hist_seg_stat     dhss,
              dba_hist_seg_stat_obj dhso,
              dba_hist_snapshot     dhs
         WHERE dhs.snap_id = dhss.snap_id
           AND dhs.instance_number = dhss.instance_number
           AND dhss.obj# = dhso.obj#(+)
           AND dhss.dataobj# = dhso.dataobj#(+)
           AND begin_interval_time BETWEEN
               to_date('<date_start>','dd.mm.yyyy hh24:mi:ss') AND
               to_date('<date_end>','dd.mm.yyyy hh24:mi:ss')
        GROUP BY dhso.object_name,dhso.object_type,dhso.tablespace_name
        ORDER BY db_block_changes desc)