SELECT dhso.object_name, object_type, SUM (db_block_changes_delta)FROM dba_hist_seg_stat dhss, dba_hist_seg_stat_obj dhso, dba_hist_snapshot dhsWHERE dhs.snap_id = dhss.snap_id AND dhs.instance_number = dhss.instance_numberAND dhss.obj# = dhso.obj#AND dhss.dataobj# = dhso.dataobj#AND begin_interval_time
BETWEEN
TO_DATE ('20-12-2012 00:00:00', 'DD-MM-YYYY HH24:mi:ss') AND TO_DATE ('20-12-201223:59:59', 'DD-MM-YYYY HH24:mi:ss')GROUP BY dhso.object_name, object_typeHAVING SUM (db_block_changes_delta) > 0ORDER BY 2, SUM (db_block_changes_delta) DESC
p.s
From