Wednesday, December 21, 2011

Change Snapshot Setting

select * from dba_hist_wr_control;


BEGIN
DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings(
retention => 66240, -- = 46 Days
interval => 15) -- = 15 Minutes
;
END;
/

No comments:

Post a Comment

Followers