How to speed up Multitenant CUSTOM database creation

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. Background Information The PDB$SEED is the – I call it – “blueprint” pluggable database. It’s sole purpose is to allow you fast provisioning of…

Alert.log: New timestamp format in Oracle 12.2

Timestamp Format Change There’s an interesting change in the alert.log since Oracle Database 12.2.0.1: 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: Oracle 12.1 Oracle 12.2 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…