I did summarize all new init.ora/spfile parameters in Oracle Database 12.2.0.1 a while ago:
And one caught Roy’s and my attention: SGA_MIN_SIZE.
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. Will the 9th and 10th PDB not startup anymore? Or will the 7th PDB already in trouble as the CDB$ROOT will need some SGA portion as …
