Re: Database upgraded to 11.2.0.4

Posted by ErmanArslansOracleBlog on Nov 29, 2022; 8:18am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Database-upgraded-to-11-2-0-4-tp11275p11282.html

Yes, gathering fixed object stats and dictionary stats may help, but you already should have done it during the upgrade, or at a later stage in the upgrade.
In my previous update, I have sent you can do about this sql.
If you are considering those stats, do it in your TEST env first.. Then take a db backup before considering doing it on PROD.