Re: storing AWR data for extended periods of time

From: Ron Warshawsky <ronwarshawsky@xxxxxxxxx>
To: ryan_gaffuri@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Thu, 26 Oct 2006 20:58:19 -0700 (PDT)

 
  Hello Ryan,
   
    Yes - we doing this routinely in automated way - please contact me if you 
need details.
   
  Thanks
   
    Ron

ryan_gaffuri@xxxxxxxxxxx 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?

References:
- storing AWR data for extended periods of time
  - From: ryan_gaffuri

Re: storing AWR data for extended periods of time

Other related posts: