Oracle Database 12.2 introduces the new split-up adaptive parameters, OPTIMIZER_ADAPTIVE_PLANS and OPTIMITER_ADAPTIVE_STATISTICS. And the key trigger to cure potential and known performance issues in Oracle Database 18.104.22.168 is enabling Oracle 12.2 ADAPTIVE Features in Oracle 22.214.171.124
For more information please see:
Enabling Oracle 12.2 ADAPTIVE Features in Oracle 126.96.36.199
But Oracle Database 12.2 on-premises is not out yet – so what should you do when upgrading to Oracle Database 12.1 – or struggling with some of the “adaptive” features in Oracle 12.1?
- MOS Note: 2187449.1
Oracle Highly Recommended Adaptive Feature Configuration Parameter Settings for 188.8.131.52.0