Database Tuning (MOSC)

MOSC Banner

Too Many AWR Intervals?

edited Aug 28, 2012 5:47AM in Database Tuning (MOSC) 13 commentsAnswered
Any idea why I have 3 AWR sampling Intervals? I didn't know you could have 3.  Seems like 2 too many.

SQL> select extract( day from snap_interval) *24*60+
  2         extract( hour from snap_interval) *60+
  3         extract( minute from snap_interval ) "Snapshot Interval",
  4         extract( day from retention) *24*60+
  5         extract( hour from retention) *60+
  6         extract( minute from retention ) "Retention Interval"
  7    from dba_hist_wr_control
  8  /

Snapshot Interval Retention Interval
----------------- ------------------
               60              11520
               15              86400
               15              43200 

Thanks!
-Ken

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center