I am not aware of any issues with long retention times either. I have worked (am working) with several systems that have over a year retention with 1 hour or half hour snapshot frequency. And I know if a guy that has plans to never purge and AWR data (I think his retention period is 7 years). Anyway, I did a blog post about reasons for having a very long retention period (one being having a permanent record of parameter changes) here: http://kerryosborne.oracle-guy.com/2009/12/tracking-parameter-changes/ There was some pretty good discussion on the issue and Doug Burns followed up with a post pointing out that there was a built in script for estimating sizing of AWR data. I personally think long retention times should be implemented (45 days at an absolute minimum 13 months more reasonable). The 7 day default is frustratingly short. Kerry Osborne Enkitec blog: kerryosborne.oracle-guy.com On Jun 24, 2010, at 10:44 PM, Allen, Brandon wrote: > I ran a system with AWR snapshots at 15 minute intervals and 45 day retention > for a couple years and never noticed any problems. > > Regards, > Brandon > > > Privileged/Confidential Information may be contained in this message or > attachments hereto. Please advise immediately if you or your employer do not > consent to Internet email for messages of this kind. Opinions, conclusions > and other information in this message that do not relate to the official > business of this company shall be understood as neither given nor endorsed by > it.