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 184.108.40.206 is enabling Oracle 12.2 ADAPTIVE Features in Oracle 220.127.116.11
For more information please see:
Enabling Oracle 12.2 ADAPTIVE Features in Oracle 18.104.22.168
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 22.214.171.124.0