Minimum Supported Version for Database Upgrades

This question comes up very often: What is the minimum supported version for database upgrades? Or a question I received today: “I have an Oracle 10.2.0.4 database, can I upgrade directly to Oracle 11.2.0.4?” Usually I have to dig into my old slides from the past to give a definite answer. And of course, the Database Upgrade Guide of each version has the same information somewhere as well. Therefore I’d like to summarize the releases supported for direct database upgrades since Oracle 11.2.0.4 below. Upgrade? When I speak about database upgrades, I mean you’ll use either the command line upgrade…

Should we wait for Oracle 19?

What a wonderful question: “We are on Oracle 11.2.0.4 right now. Should we wait for Oracle 19 because of the proposed long term support for this release?” I have gotten this question roughly 15 times in the past week, raised either by colleagues, customers or partners via email, twitter, in web conferences or (old fashioned way) on the phone. People refer to the graph printed in MOS Note: 742060.1. And I won’t replicate it here as this graph can change anytime. And it got adjusted just a few weeks ago as the support timeline for Oracle 12.2.0.1 was drawn too…

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…

Parallel Index Creation with Data Pump Import

Here is a new capability that might be interesting to anybody who is performing a migration using Data Pump. Previously, Data Pump would create indexes one at a time, specifying the PARALLEL keyword for the CREATE INDEX statement to invoke parallel query for index creation. We used to recommend a workaround to create indexes in parallel, which involved a three-step process of importing without indexes, then creating a SQLFILE of the CREATE INDEX statements, and breaking that file into multiple windows. Through extensive performance testing we found that it is faster to create multiple indexes in parallel (using a parallel…