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 22.214.171.124 is enabling Oracle 12.2 ADAPTIVE Features in Oracle 126.96.36.199
For more information please see:
Enabling Oracle 12.2 ADAPTIVE Features in Oracle 188.8.131.52
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 184.108.40.206.0