RE: Long term AWR retention
- From: "Stephens, Chris" <Chris.Stephens@xxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 14 Nov 2011 15:38:31 -0600
If space is an issue in the database you would like to keep historical AWR data
for, then you can always export the AWR data via the scripts provided in
$ORACLE_HOME/rdbms/admin and build a dba data warehouse on a separate server
for analysis across all databases.
That also (obviously) has the benefit of offloading any resource intensive SQL
you would like to run against the captured performance data.
I think Mark Farnham (sp?) was the first person I noticed pushing this idea and
I have plans to implement this in the very near future.
Chris
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Allen, Brandon
Sent: Thursday, November 10, 2011 12:31 PM
To: sacrophyte@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Long term AWR retention
Just something else to keep in mind – it can take a significant amount of space
to store a lot of history, especially if you increase the frequency of
snapshots to 15 minutes like I do and run them 24x7. On one of my systems the
perfstat schema is about 12GB for approximately 6 months of snapshots taken at
15 minute intervals 24x7. I’m guessing AWR would be similar. I know 12GB
isn’t huge by today’s standards, but just something to consider. If you use
statspack you can cut down on the space consumption by increasing the
thresholds for the top SQL that is captured. Tim Gorman has a good script for
that here:
http://www.evdbt.com/spparms.sql
I think you can do the same thing for AWR but can’t remember for sure off the
top of my head.
Regards,
Brandon
----------------------------------------------------
From: Charles Schultz [mailto:sacrophyte@xxxxxxxxx]
Sent: Thursday, November 10, 2011 10:38 AM
What is the real downside to setting retention to something, like, 10 years?
________________________________
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.
--
//www.freelists.org/webpage/oracle-l
CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is privileged,
confidential and exempt from disclosure under applicable law. If the reader of
this message is not the intended recipient or the employee or agent responsible
for delivering this message to the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. If you have received this communication in error, please
notify us immediately by email reply.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
