Re: Adaptive plans in EBS database performance

Posted by ErmanArslansOracleBlog on Jul 05, 2023; 11:35am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Adaptive-plans-in-EBS-database-performance-tp11973p11976.html

However, for 19C here it is ->

#
# Optimizer parameters.
#
# In Oracle Database 12.2 or higher, the Parameter optimizer_adaptive_features has been obsoleted,
# replaced and controlled by two new parameters, optimizer_adaptive_plans, which defaults to TRUE and
# optimizer_adaptive_statistics, which defaults to FALSE. For more details Refer MOS DOC ID 2031605.1.
#
##########

optimizer_adaptive_plans = TRUE #MP
optimizer_adaptive_statistics = FALSE #MP