Adpative Features Patches with Oracle Peoplesoft

Adaptive Feature Patches with Oracle Peoplesoft - Accenture Enkitec's ExperienceI’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 for every Proactive Bundle Patch over and over again. But based on our experience these two patches fix most of the nasty issues with and around “adaptive” in Oracle 12.1.0.2.

    • The patch# 22652097 introduces the two parameters OPTIMIZER_ADAPTIVE_PLANS and OPTIMIZER_ADAPTIVE_STATISTICS. In addition removes the parameter OPTIMIZER_ADAPTIVE_FEATURES.
    • The patch# 21171382 disables the automatic creation of extended statistics unless the optimizer preference AUTO_STATS_EXTENSIONS is set to ON.

Experience with Oracle Peoplesoft

Now a while later David has mailed me with his first-hand experience. And he shared his blog post with me.

In short (I did ask for David’s permission to quote him):

“We have had the patches in place on our supercluster for a few weeks, and I have been working on tuning the GL reporting.
It has been positive.  It hasn’t fixed all our problem, but it certainly hasn’t added to them.  I have seen plans switching mostly from NL to Hash, but I have not found a case where I think that was a bad decision. I just wanted to say thank you for your assistance with this. 
I shall certainly be recommending this as standard practice for PSFT on 12cR1.

But you better should read the entire blog post:

http://blog.psftdba.com/2017/06/peoplesoft-adaptive-query-optimization.html

Further Information

Please find Required Interim Patches and PSFT recommended Oracle 12c init.ora parameters for the Oracle Database with PeopleSoft in MOS Note:1100831.1 which does not yet include the above patches.

–Mike

 

2 thoughts on “Adpative Features Patches with Oracle Peoplesoft

    • Hemant,

      as I wrote, unfortunately not. You’ll have to request them over and over again unless you are on Oracle 12.2.

      Cheers
      Mike

Leave a Reply

Your email address will not be published. Required fields are marked *