Modify AWR Default Snapshot settings.
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



Modify AWR Default Snapshot settings. Expand / Collapse
Message
Posted 9/8/2009 3:02:20 PM Post #153
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

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;
/

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 7:25am

Powered By InstantForum.NET v4.1.4 © 2010
Execution: 0.058. 7 queries. Compression Disabled.