In an Oracle Container Database, SYSDBA, SYSDG, SYSBACKUP etc. privileges canbe granted on PDB level. This enables PDB administrators with their localusers e.g. to open and to close a PDB. How does this work and where isthis privilege information stored?
Thanks to everyone, who attended my presentation on “The 3 investigators” (OraChk, TFA and DBSAT) at the OUGN Spring Seminar 2018 on “MS Color Fantasy“. Here you can find the presentation.
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?