Re: Database upgraded to 11.2.0.4

Posted by ErmanArslansOracleBlog on Nov 28, 2022; 2:47pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Database-upgraded-to-11-2-0-4-tp11275p11277.html

You can get the old (performing well) execution plan from your 11.1.0.7 database and fix it in the newly database. (or you can use AWR for getting that old execution plan and fix that) Example for getting it for AWR ->  select * from table(dbms_xplan.display_awr('<sql_id>'));