Thursday, July 9, 2009

Change AWR snapshot frequency

select * from dba_hist_wr_control;

execute dbms_workload_repository.modify_snapshot_settings
( interval => 10,
retention => 14400);

select * from dba_hist_wr_control;