Re: Disable awr snapshot before upgrade

Posted by satish on Nov 04, 2022; 1:17am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Disable-awr-snapshot-before-upgrade-tp11193p11197.html

Thanks erman.

This is ebs database.During downtime,can we run this command?We have 4 core cpu dual processor.

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

Can we use Gather Stale or AUTO.Since we are moving to prod next week,we just want to make sure.

Thanks you,
Satish