Fixes for Adaptive Features are included in Oracle 12.1.0.2 October 2017 BP

Finally … the two most important fixes for Adaptive Features are included in Oracle 12.1.0.2 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. And we all knew – also based on the experience of the Real World Performance Team – that these two patches are so important to stabilize Oracle 12.1.0.2 production systems. You may find this ALERT on MyOracle Support: MOS Note 2289719.1 ALERT: Oracle Recommended Adaptive Feature Configuration…

Adpative Features Patches with Oracle Peoplesoft

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. He did ask me questions about the adaptive features patches I was recommending in my talk: Enabling ADAPTIVE Features of Oracle 12.2 in 12.1 The Adaptive Feature Patches I explained to him that he will have to request these specific two fixes unfortunately…

Adaptive Execution Plans – not available in Oracle SE2

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? The Oracle Database 12.2 License Guide says: 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? That is the question Adam had. Does this impact SE2? Will I get an error or – even worse – a license violation if I have optimizer_adaptive_plans=TRUE – which is the default? No, none of it will…