Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: storing AWR data for extended periods of time

Re: storing AWR data for extended periods of time

From: Ron Warshawsky <ronwarshawsky_at_yahoo.com>
Date: Thu, 26 Oct 2006 20:58:19 -0700 (PDT)
Message-ID: <20061027035819.68020.qmail@web30608.mail.mud.yahoo.com>

 

  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-l
Received on Thu Oct 26 2006 - 22:58:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US