Monthly Archives: April 2014

Diag and Tuning Pack: disable the beast

11g and 10g changes: – Baselines: begin for m in (select * from dba_hist_baseline where baseline_name != ‘SYSTEM_MOVING_WINDOW’) loop sys.dbms_workload_repository.drop_baseline(baseline_name=>m.baseline_name,cascade=>true); end loop; end ; / – Manual Snapshots: begin for m in (select * from dba_hist_snapshot where snap_flag0) loop sys.dbms_workload_repository.drop_snapshot_range(low_snap_id=>m.snap_id,high_snap_id=>m.snap_id); … Continue reading

Posted in Uncategorized | Leave a comment