How to find AWR snapshot interval and retention settings?
In below Query will give you retention in Days and Snap_Interval in Minutes.
col snap_interval format a30
col retention format a30
select snap_interval,
retention
from dba_hist_wr_control
/
No comments:
Post a Comment