I did summarize all new init.ora/spfile parameters in Oracle Database 188.8.131.52 a while ago:
New SPFILE parameters in Oracle Database 184.108.40.206
And one caught Roy’s and my attention:
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]
Two weeks ago I published a blog post about Parameter Recommendations for Oracle Database 220.127.116.11. And I took it down a day later. Why that?
I’ve got a lot of input from external sources for the “Parameter” blog post. And I’d like to thank everybody who contributed to it, especially Oracle ACE Ludovico Caldara.… [Read More]
Roy today answered an interesting question on one of our internal mailing lists. And this reminds me to pick up that piece of information as we see this quite often on customer sites, especially after upgrades or migrations. People set OPTIMIZER_FEATURES_ENABLE (OFE) to revert the optimizer’s behaviour to another pre-current release.… [Read More]
Patchset 18.104.22.168 is out there for a long, looong time. But still Roy and me – and unfortunately our customers – sometimes experience some nice surprises after upgrade.
Roy did work on the weekend with a financial institution customer in the US to support them during their go-live on Oracle 22.214.171.124 with several systems.… [Read More]