Re: Disable awr snapshot before upgrade

Posted by ErmanArslansOracleBlog on Nov 03, 2022; 2:30pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Disable-awr-snapshot-before-upgrade-tp11193p11195.html

Maybe as last resort, but we don't want to do anything to affect production performance and we don't want to do this by going beyond the limits, beyond the documentation I mean.. Even for 1 day.. Even 1 day before the upgrade. That's why we got to try to fix it first..

For instance; did you try to run it in parallel?

EXEC DBMS_STATS.GATHER_DICTIONARY_STATS ( options => 'GATHER STALE', DEGREE => 16);