Setting OPTIMIZER_ADAPTIVE_FEATURES in Oracle Database 12c Release 2
In Oracle Database 12c Release 2 the parameter OPTIMIZER_ADAPTIVE_FEATURES was declared “Obsolete”. It was replaced by the parameters optimizer_adaptive_statistics, optimizer_adaptive_plans and AUTO_STAT_EXTENSIONS to allow better control of the adaptive features of the optimizer but what happens, if you try the set OPTIMIZER_ADAPTIVE_FEATURES on a 12.2 database?
DBCA 12.2 runs datapatch automatically
It was one of the issues with Oracle 12c Release 1 that datapatch was not executed by dbca automatically. So, if you had installed patches to your Oracle home before running dbca, dbca did not take this into consideration and ran datapatch to apply the SQL changes to the databases. In August 2015 Mike Dietrich…