I have received several questions from customers in the past weeks using Oracle Multitenant about the parameter exclude_seed_cdb_view.It magically disappeared and morphed into _exclude_seed_cdb_view since Oracle Database 18.104.22.168. To be fair, the exclude_seed_cdb_viewis listed in the list of obsolete parameters in Oracle Database 22.214.171.124.
What is EXCLUDE_SEED_CDB_VIEW?
This parameter hides everything belonging to the PDB$SEED from the usual queries.… [Read More]
When we present this new parameter as part of the Multitenant slides in our workshops, some people ask themselves:
“What happens if I oversubscribe such a parameter?” For example, if SGA_TARGET=4G and I have 10 PDBs and define in each of them SGA_MIN_SIZE=500M.… [Read More]
New Parameters in Oracle Database 126.96.36.199 with July 2016 PSU/BP
By following an internal discussion and checking parameter changes between Patch Set Updates (PSU) and Proactive Bundle Patches (BP) I learned that we introduced two new SPFILE parameters in Oracle Database 188.8.131.52 with the July PSU and BP. One is documented in the patch readme, the other one can be found right now only in the Oracle Database 184.108.40.206 manual:
Oracle Database 12.2 introduces the new split-up adaptive parameters, OPTIMIZER_ADAPTIVE_PLANS and OPTIMITER_ADAPTIVE_STATISTICS. And the key trigger to cure potential and known performance issues in Oracle Database 220.127.116.11 is enabling Oracle 12.2 ADAPTIVE Features in Oracle 18.104.22.168