Patch 22652097 in 12.1 makes optimizer_adaptive_features parameter obsolete

After having several issues with adaptive features on 12.1 databases, in some cases, the quickest way to solve problems was to simply set ‘optimizer_adaptive_features’ parameter to FALSE. In 12.2, this parameter became obsolete and was replaced with two different parameters : ‘optimizer_adaptive_plans’ and ‘optimizer_adaptive_statistics’. Therefore, it is recommended to apply Patch 22652097 (PROVIDE SEPARATE CONTROLS […]

Read More

Impdp tip : exclude content of a table and include metadata at once

I am currently in the process of migrating a 150 Gb Oracle 10g database to 12c. Due to some limitations I won’t discuss here, I have to do it with Datapump. As I encountered different problems during the import, I had to launch it several times. It took 2 hours to import a 120 Gb […]

Read More

ODC Appreciation Day : EM CLI

When I first started as a DBA two years ago, the colleague in charge of my training thought that I would rather use several GUIs to complete most of the tasks. He said it was because of my age … But he quickly found out that I was more comfortable with CLIs. For this very […]

Read More