Showing posts with label AWR. Show all posts
Showing posts with label AWR. Show all posts

Thursday, August 27, 2015

How to tell if AWR data takes up too much space in SYSAUX tablespace

Are you looking for ways to reduce space in your environment?  Check out My Oracle Support note 287679.1 for the article "How to Address Issues Where AWR Data Uses Significant Space in the SYSAUX Tablespace" so you can validate your settings and find out if there are ways to eliminate extra data including orphaned records!

Wednesday, July 30, 2014

AWR Interval discussion

A few weeks ago I shared several posts from Doug Burns about incremental global stats, and today are several posts from Doug on AWR Internal here and here.  Why am I suddenly thinking about this subject?  Well I keep an eye on our alert which monitors ASH data every hour as I've said many, many times before and this is absolutely a good discussion about what tools are useful when (especially if you read the comments of the first AWR post from Doug).