DBMS_OPTIM_BUNDLE – only available in Oracle – or not?

The DBMS_OPTIM_BUNDLE package got introduced with the April 2014 Exadata Bundle Patch. And it got introduced for all Oracle databases with the April 2017 Bundle Patch (BP). DBMS_OPTIM_BUNDLE is only available in Oracle 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 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 The package got introduced to enable module bug fixes which cause…

Things to consider BEFORE upgrading to Oracle 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 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….