Uwe Kirchhoff, one of the best techies I know in the entire Oracle CSS (formerly ACS) Support, mailed me before the Christmas holidays with a simple question. He discovered that altering init.ora parameters in a session does not necessarily write the parameter down into the spfile. Sounds a bit like Voodoo with init parameters, and Oracle Restart has a role in this story as well. If you don’t have or do not plan to use Oracle Restart, then this is not interesting for you. But of course, you are free to still read it 🙂… Continue reading...
Many thanks to a German customer for showing me this tiny behavior change with Oracle Database RU 19.4.0. From this RU on the well known ORA-1555 won’t get reported into alert.log anymore since 19.4.0. But if you still like to see the “
snapshot too old” error, then you can use a workaround.
Why has this been changed?
Actually this is something I don’t understand completely. It may be just a side effect. Unpublished fix bug 29424999 – DUMP MINIMAL DIAGNOSTICS BY DEFAULT IN CASE OF ORA-01555 IN ADW/ATP ENV has been …Continue reading...
I usually create my container databases for testing with the
CUSTOM option of DBCA. That allows me to specify exactly the components I’d like to have – or not. But I realized two things during the
CUSTOM creation: It takes very long. And in the
alert.log I see resize operations especially with the
PDB$SEED during dictionary view creation. I see heap warnings. And recompilations. I did ask myself how to speed up Multitenant
CUSTOM database creation.
PDB$SEED is the – I call it – “blueprint” pluggable database. It’s sole purpose is to allow you fast provisioning of …
Timestamp Format Change
There’s an interesting change in the alert.log since Oracle Database 184.108.40.206: The format of the timestamps has changed.
If you compare the timestamps in Oracle 12.1 vs Oracle 12.2 you’ll recognize the change immediately:
Wed Feb 08 15:39:29 2017 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT Wed Feb 08 15:39:29 2017 ALTER DATABASE OPEN Wed Feb 08 15:39:29 2017 Ping without log force is disabled. Starting background process TMON
2017-05-29T14:09:17.064493+02:00 Database mounted in Exclusive Mode Lost write protection disabled Completed: ALTER DATABASE MOUNT 2017-05-29T14:09:17.252853+02:00 ALTER DATABASE OPEN