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