Oracle Multitenant – SYS*-privileges on PDB level
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?
OUGN Spring Seminar 2018: Presentation “Domain Services Cluster”
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.
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?