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