-- -- Show the Object Name that Created the Most Redo for the Time Period Specified -- SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 60 SET LINESIZE 300 SELECT dhso.object_name, SUM (db_block_changes_delta) 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 ('2022-03-05 14', 'YYYY-MM-DD HH24') AND TO_DATE ('2022-03-05 22', 'YYYY-MM-DD HH24') GROUP BY dhso.object_name ORDER BY SUM (db_block_changes_delta) DESC /