Tag Archives: Oracle database 12.2

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 … Continue reading

Posted in Oracle 12c | Tagged , | Comments Off on Setting OPTIMIZER_ADAPTIVE_FEATURES in Oracle Database 12c Release 2

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 … Continue reading

Posted in Common, Oracle 12c | Tagged , , | Comments Off on DBCA 12.2 runs datapatch automatically