Finally … the two most important fixes for Adaptive Features are included in Oracle 220.127.116.11 October 2017 BP (Bundle Patch). I’m absolutely happy about this. Almost all of my customer and many folks outside I’m dealing with on a regular basis had to request and wait for merge patches over and over again.… [Read More]
Oracle 12.2 adaptive features are enabled in Oracle 18.104.22.168 Windows BPs already, This is quite a surprise to me. But thanks to Michael Pfautz. He alerted me today.as he was wondering why his database didn’t start up anymore after he applied the August 31 Bundle Patch on Windows. It complained about the parameter
optimizer_adaptive_features in the SPFILE.… [Read More]
DBMS_OPTIM_BUNDLE package got introduced with the April 2014 Exadata 22.214.171.124 Bundle Patch. And it got introduced for all Oracle 126.96.36.199 databases with the April 2017 Bundle Patch (BP).
DBMS_OPTIM_BUNDLE is only available in Oracle 188.8.131.52.
For more information on this package on Exadata in Oracle 184.108.40.206 you may look at:
Purpose of DBMS_OPTIM_BUNDLE package in Oracle 220.127.116.11
The package got introduced to enable module bug fixes which cause an execution plan change in a disabled state.… [Read More]
I’ve met David Kurtz, an Oracle ACE Director working for Accenture’s Enkitec division in the UK earlier this year on the OUGN Conference‘s boat trip from Oslo to Kiel and return. We set across the table at dinner. And of course we started discussing “Oracle”. David went to my talk about “How to ensure Performance Stability” before.… [Read More]
I received an interesting question on the blog the other day:
“Are Adaptive Plans an Enterprise Edition only feature?”
What does the License Guide say?
What does www.oracle.com say?
This is the link the customer came across – also saying that Adaptive Execution Plans are an Enterprise Edition only feature:
What does this mean for SE2?… [Read More]
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?… [Read More]
The Oracle Database 12.1 parameter OPTIMIZER_ADAPTIVE_FEATURES has been made OBSOLETE (i.e. must be removed from the SPFILE when upgrading) in Oracle Database 12.2.
It gets replaced with two parameters of whom one is enabled, the other one is disabled by default:
- OPTIMIZER_ADAPTIVE_PLANS=TRUE by default
- OPTIMIZER_ADAPTIVE_STATISTICS=FALSE by default
Nigel Bayliss, our “Optimizer” Product Manager has blogged about it already with way more detailed insights.… [Read More]