I did blog in the past weeks about Fallback Strategies with Flashback Database. But two of my reference customers came across an interesting issue when they tried to fallback: Oracle 12.2 underscores appear in the SPFILE – magically – and prevent the fallback using the existing SPFILE.
Oracle 12.2 underscores appear in SPFILE – be aware when you flashback
In one case it happened during a test, in the other case it happened during a live fallback after the Data Guard Broker has interfered with the upgrade causing real trouble.… [Read More]
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]