How often we collect the stastics for generating AWR reports
|
11121
2010-MAR-06 07:35:55
|
|
User
|
|
|
Registered On: Feb 2010
Total Posts: 24
|
|
Hi
I just want to know "how often we collect the statistics for generating AWR
reports, while we are collecting the statistics then obviously it will impact
the database performance, So what is the idle time for collecting statistics?
|
11129
2010-MAR-08 20:32:03
|
|
Moderator
|
|
|
Registered On: Mar 2006
Total Posts: 289
|
|
By default snapshot are generated once every 60min and maintained for 7 days.
That has been sufficient for our shop.