A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

Month: September 2023

white paper 1 min read

SELECT to_char(begin_interval_time,’YY-MM-DD HH24′) snap_time, dhso.object_name, sum(db_block_changes_delta) BLOCK_CHANGED 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...