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…

DBMS_OPTIM_BUNDLE – only available in Oracle 12.1.0.2 – or not?

The DBMS_OPTIM_BUNDLE package got introduced with the April 2014 Exadata 11.2.0.4 Bundle Patch. And it got introduced for all Oracle 12.1.0.2 databases with the April 2017 Bundle Patch (BP). DBMS_OPTIM_BUNDLE is only available in Oracle 12.1.0.2. Addition March 6, 2018: See the updated blog post about DBMS_OPTIM_BUNDLE available in Oracle 12.2 and 18c onwards. https://mikedietrichde.com/2018/03/08/dbms_optim_bundle-package-oracle-12-2-18c/ For more information on this package on Exadata in Oracle 11.2.0.4 you may look at: MOS Note:1942966.1: Exadata: DBMS_OPTIM Package Philippe Fierens’ blog post from October 2014 Purpose of DBMS_OPTIM_BUNDLE package in Oracle 12.1.0.2 The package got introduced to enable module bug fixes which cause…

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…

Parameter Recommendations for Oracle Database 12c – Part I

See also: Parameter Recommendations for Oracle Database 12c – Part II A few weeks ago we’ve published some parameter recommendations including several underscores but based on an internal discussion (still ongoing) we decided to remove this entry and split up the tasks. The optimizer team will take over parts of it and I’ll post an update as soon as something is published. Preface Please be advised – the following parameter list is mostly based on personal experience only. Some of them are officially recommended by Oracle Support. Always use proper testing mechanisms. We strongly recommend SQL Performance Analyzer to verify the effect of any of those…

PSU (and CPU/SPU) October 2015 got released

October 21, 2015 – Oracle released the October 2015 SPU/CPU, PSU and BPs. See: Patch Set Update Availability MOS Note:756671.1 Oracle Recommended Patches — Oracle Database October 2015 PSU/CPU: MOS Note: 2037108.1 Patch Set Update and Critical Patch Update October 2015 Availability Document CPU Security Alerts October 2015 http://www.oracle.com/technetwork/topics/security/cpuoct2015-2367953.html For Oracle Database 12.1.0.2 and Oracle Grid Infrastructure access the PSUs from here – if you have only a single instance database you can safely take the Combo patch as you’ll get downtime anyways – but for customers running RAC you need to evaluate the OJVM component as this will incur…

SQL Plan Management – Known Issues in Oracle 12.1.0.2

Our Support colleagues released the patch recommendation note for SQL Plan Management (SPM) for Oracle Database 12.1.0.2. MOS Note:2035898.1 Patches to Consider for 12.1.0.2 to Avoid Problems with SQL Plan Management (SPM) In the unlikely event you’d like to upgrade to Oracle Database 11.2.0.4 or (very very unlikely hopefully) 11.2.0.3 please see these matching notes: MOS Note:2034706.1 Patches to Consider for 11.2.0.4 to Avoid Problems with SQL Plan Management (SPM)) MOS Note:1948958.1 Patches to Consider for 11.2.0.3 to Avoid Problems with SQL Plan Management (SPM) Some additional things to mention: SPM is an Oracle Enterprise Edition feature at no extra…

Things to consider BEFORE upgrading to Oracle 12.1.0.2 to AVOID poor performance and wrong results

Finally it got published on MyOracle Support (MOS) portal – one of the most helpful notes when we prep for an upgrade or a migration – and potentially the one with the longest title in MOS: MOS Note: 2034610.1 Things to consider BEFORE upgrading to Oracle Database 12.1.0.2 to AVOID poor performance and wrong results  One important note regarding these “Things to Consider” notes: They will only list issues where either a fix or a proven workaround is available. They don’t list all open issues nor do they recommend every given underscore which may cure one or the other misbehavior….

DBUA 12c and “datapatch.pl” – things to know

For clarification: The following blog post applies to upgrades to Oracle 12.1 done by DBUA only whenever a SPU/PSU/BP is installed into the 12.1 home prior to the upgrade (which I’d highly recommend as patching before upgrade saves you headache after upgrade!). Update [Dec 10, 2015]: The required patch is included in  12.1.0.2BP13 but not 12.1.0.2.PSU5 (Oct 2015) – it will be included in the 12.1.0.2.PSU6 (Jan 2016) and all following PSUs. Update: For Oracle Database 12.2 and newer please see: https://mikedietrichde.com/2017/05/25/dbca-execute-datapatch-oracle-database-12-2/ Two customers independently reported last week that they have doubts on DBUA’s ability to apply the required SQL…

Avoid Poor Performance and Wrong Results in 11.2.0.4

One of the best notes in MOS got refreshed last night for Oracle Database 11.2.0.4. It has not only information about performance bugs but also about the worst and meanest category of issues, wrong query result bugs. Those are the ones I call the “sleeping beauties” as you as a DBA usually won’t recognize them. It is recognized at the application level when the result of a report is incorrect or instead of 4 rows just 3 rows get delivered in the output. Therefore you should be highly aware of those and add this note to your bookmarks. MOS Note…

October 2013 PSUs and CPUs – News for 12c

Last night CET the most recent Patch Set Updates (PSU) and Critical Patch Updates (CPU aka SPU) got published on MOS. And there’s a significant and remarkable change for Oracle Database 12c onwards. MOS Note: 1571391.1 – Patch Set Update and Critical Patch Update October 2013 Availability Document says: 2.1 Database Security Patching from 12.1.0.1 Onwards Starting with Oracle Database version 12.1.0.1, Oracle only provides Patch Set Updates (PSU) to meet the Critical Patch Update (CPU) program requirements for security patching. Security Patch Updates (SPU) will no longer be available. Oracle has moved to this simplified model due to popular demand….