Skip to Main Content
  • Questions
  • Reducing AWR snapshot time period and its consequences

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: September 30, 2020 - 6:58 pm UTC

Last updated: October 06, 2020 - 8:23 am UTC

Version: 11.2.0.2.0

Viewed 1000+ times

You Asked

Hi,
Can we make awr report time period to be 30 minutes instead of 1 hour? If we do that, does it affect the performance?

and Connor said...

Capturing a snapshot is not "free" obviously, but 30mins typically is no cause for concern, and my personal experience has been 1hour tends to smooth things out too much. If you have a disaster for 15mins, but the other 45mins is fine, the whole hour tends to look "OK"

In particular, I've also known of customers who have gone to 5 or 10mins for particular performance analysis with no major issues, ie, they run at (say) 20mins, but if they want to track a particular time frame that is critical, they'll bump it to 5mins for an hour or so, and then back out to 20 or 30 when done.

Obviously more snapshots means more space etc...so common sense is always the key here.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.