EBS database upgrade - concurrent requests query performance

Posted by satish on Oct 19, 2022; 12:31pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/EBS-database-upgrade-concurrent-requests-query-performance-tp11138.html

Hi erman,

We are upgrading ebs database 11.1.0.7 to 11.2.0.4
Application version R12.1.3

Our concern was , as we have currently in our existing database many sqls using "sql plan baselines" and other using "sql profiles" , so basically we are currently using these to make oracle follow a fixed execution path for those sqls all the time and thus we have "optimizer_use_sql_plan_baselines" is set as TRUE(which is default one).

But in addition to this when we will set "optimizer_capture_sql_plan_baselines" as TRUE few days before upgrade , in first attempt Optimizer will create/capture new baselines for all the sqls. So my worry was that if this will override any existing baselines/sql profiles which are in use for the critical sqls. considering we dont have SYS_AUTO_SPM_EVOLVE_TASK turned ON), the new baseline has to pass through a manual plan evolution process before its gets in use by the existing query, so we are safe in that perspective as it wont automatically utilize new baselines without our notice. Please correct me if wrong.

Thanks,
Satiah