Re: EBS database upgrade - concurrent requests query performance

Posted by ErmanArslansOracleBlog on Oct 20, 2022; 9:55am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/EBS-database-upgrade-concurrent-requests-query-performance-tp11138p11145.html

Facts:
-----------
*OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES enables or disables the automatic recognition of repeatable SQL statements, as well as the generation of SQL plan baselines for such statements.

*Automatic Plan Capture
The value of the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter, whose default value is FALSE, determines if the system should automatically capture SQL plan baselines. When set to TRUE, the system records a plan history for SQL statements. The first plan for a specific statement is automatically flagged as accepted. Alternative plans generated after this point are not used until it is verified they do not cause performance degradations. Plans with acceptable performance are added to the SQL plan baseline during the evolution phase.

So, if you don't have an automatic evolution, then yes you re safe from that perspective.

Also see -> Automatic SQL Plan Baselines (Doc ID 1930525.1)

Why did you enable optimizer_capture_sql_plan_baselines at this point?