Performance stats retention
From: Lok P <loknath.73_at_gmail.com>
Date: Fri, 4 Feb 2022 01:48:46 +0530
Message-ID: <CAKna9Va=Xg2xD__McEpcfjaxW8MgFS9JXUR=tcdm0AaqgOQTTg_at_mail.gmail.com>
Hello Listers, In many of our customer databases(combination of Version 11.2 and 19C) we have daily and monthend processes runs and that is why we normally set the AWR retention period to >65 days to have visibility for the last two months back activity , so as to look into any performance issues and compare things back in days.It is helping us significantly in triaging production issues. Though these AWR data were consuming storage space on sysaux tablespace but we have not seen any performance issue as such because of this. We have been asked to do the same for cell metrics too by increasing the retention i.e. 'metrichistorydays' parameter. Currently it default 7days. So wanted to understand from experts here , 1)If this will have any negative impacts? 2) How will these metrics be different from the ones displayed in the AWR report? As because in AWR report we do see the exadata cell flash cache, disk related stats all the way back till we have the set awr retention period i.e.>65days(even we have metrichistorydays set as default 7 days ).
Date: Fri, 4 Feb 2022 01:48:46 +0530
Message-ID: <CAKna9Va=Xg2xD__McEpcfjaxW8MgFS9JXUR=tcdm0AaqgOQTTg_at_mail.gmail.com>
Hello Listers, In many of our customer databases(combination of Version 11.2 and 19C) we have daily and monthend processes runs and that is why we normally set the AWR retention period to >65 days to have visibility for the last two months back activity , so as to look into any performance issues and compare things back in days.It is helping us significantly in triaging production issues. Though these AWR data were consuming storage space on sysaux tablespace but we have not seen any performance issue as such because of this. We have been asked to do the same for cell metrics too by increasing the retention i.e. 'metrichistorydays' parameter. Currently it default 7days. So wanted to understand from experts here , 1)If this will have any negative impacts? 2) How will these metrics be different from the ones displayed in the AWR report? As because in AWR report we do see the exadata cell flash cache, disk related stats all the way back till we have the set awr retention period i.e.>65days(even we have metrichistorydays set as default 7 days ).
Thanks & Regards
Lok
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 03 2022 - 21:18:46 CET