Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: storing AWR data for extended periods of time
Hello Ryan,
Yes - we doing this routinely in automated way - please contact me if you need details.
Thanks
Ron
ryan_gaffuri_at_comcast.net wrote:
We talked about storing AWR data for 3 months to as long as 18 months. There is some concern that this might increase contention on the SYSAUX tablespace. We talked about copying the data over to another schema/tablespace every 7 days and setting the retention to 7 days. Has anyone does this? Is there a need to do this?
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 26 2006 - 22:58:19 CDT
![]() |
![]() |