DBMS_OPTIM_BUNDLE Package in Oracle 12.2 and 18c

Yes, I did blog about the DBMS_OPTIM_BUNDLE package in earlier Oracle releases before. And I thought (and it was documented this way) that it will disappear in Oracle 12.2 and newer. But in fact you’ll find the DBMS_OPTIM_BUNDLE package in Oracle 12.2 and 18c. Most likely … This is a very interesting case and you may see also my previous blog posts: DBMS_OPTIM_BUNDLE – only available in Oracle 12.1.0.2 – or not? Fixes for Adaptive Features are included in Oracle 12.1.0.2 October 2017 BP Package Differences between Oracle 11.2.0.4 and 12.1.0.2? DBMS_OPTIM_BUNDLE Package in Oracle 12.2 and 18c First of…

Gather SQL Statements from AWR and Cursor Cache without need for Diag and Tuning Packs

When we talk about database upgrades and migrations the most important (and unfortunately time-/resource consuming) activity is testing. But often testing resources are limited or, even worse, don’t exist. I’ve worked with customers where we migrated a core EBS system off AIX to Linux – but only got a 6 year old Tru64 box for testing purposes (where the recompilation took 20x as long as later on the production environment). Or the classic one: Database is too big thus we test only with 10% of the data. I know that often your hands are tied. Everybody wants an 1:1 duplicate…

Package Differences between Oracle 11.2.0.4 and 12.1.0.2?

The question sounds pretty trivial: Which packages did exist in Oracle 11.2.0.4 but don’t exist in Oracle 12.1.0.2 anymore? And going a bit deeper into the topic, Which procedures and functions calls of SYS packages have been changed since then? A colleague of mine (thanks to Thomas Kempkens from ACS Support for writing up a fancy procedure – all credits go to him) had to dig this out for a customer, See the result. These packages don’t exist in Oracle 12.1.0.2 anymore but did exist in Oracle 11.2.0.4 (without PSUs): CWM2_OLAP_INSTALLER DBMS_AMD DBMS_APPCTX DBMS_DBLINK DBMS_DM_IMP_INTERNAL DBMS_DM_UTIL_INTERNAL DBMS_DUMA_INTERNAL DBMS_JDM_INTERNAL DBMS_RULE_COMPATIBLE_90 DBMS_SQL2…