What happens when you start up 252 PDBs (Pluggable Databases) with the Oracle Multitenant Option for the first time?
Interesting question, isn’t it? The expectation would be that this will happen within seconds as the SGA and therefore the shared memory segments are already allocated from within the CDB$ROOT (Container Database). But …
The following happens:
It takes minutes … hours …. In my tiny lab environment with just as little as 20 PDBs due to space constraints it takes over 30 minutes to startup 21 PDBs. Takashi Ikeda from Fujitsu Hokoriku Systems who did a great demo with the …