Modify AWR Default Snapshot settings.

Admin — Tue, 08 Sep 2009 15:02:20 GMT

Here is how you can modify AWR Default Snapshot settings.

BEGIN
DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings(
retention => 21600, -- Minutes (= 15 Days).Current value retained if NULL.
interval => 60); -- Minutes. Current value retained if NULL.
END;
/

FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / Oracle Database Administration / Modify AWR Default Snapshot settings. / Latest Posts

Modify AWR Default Snapshot settings.