Re: EBS database upgrade - concurrent requests query performance

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

Thanks erman.

We enabled it to capture all sql run by concurrent requests,forms,etc.. After upgrade completed,if any sql performance is bad,then we can revert old plan using baseline.

after upgrade if we see any plan deviation with new optimizer version for any query (which was not having any old sql profile/sql plan baselines associated with it before). Then we can simple follow the dba_sql_plan_baselines, to scan through the captured baselines those created just before upgrade and can evolve those and use those to get the plan back in as it used to in old version. Please correct me if my understanding

You might have done multiple upgrades.Pls help us if there is any other alternative.

Thanks,
Satish