1.292 SGA_MIN_SIZE

SGA_MIN_SIZE sets the guaranteed SGA size for a pluggable database (PDB). When SGA_MIN_SIZE is set for a PDB, it guarantees the specified SGA size for the PDB.

Property	Description
Parameter type	Big integer
Syntax	`SGA_MIN_SIZE =` `integer` `[K \| M \| G]`
Default value	`0`
Modifiable	`ALTER SYSTEM`
Modifiable in a PDB	Yes
Range of values	0 to 50% of `SGA_TARGET`
Basic	No
Oracle RAC	The same value must be used for all instances.

Setting this parameter at the CDB level has no effect.

Note:

To be able to use Resource Manager in a CDB to control the amount of memory each PDB can use:

The NONCDB_COMPATIBLE initialization parameter must be set to FALSE at the CDB level (in the root of the CDB).
The MEMORY_TARGET initialization parameter must not be set at the CDB level.
A value for SGA_TARGET must be set at the CDB level.

If SGA_TARGET is not set at the CDB level, then setting SGA_MIN_SIZE in a PDB has no effect. You will not receive an error message, and the PDB’s SGA_MIN_SIZE value will not be enforced.
You must set the SGA_MIN_SIZE value to a value that meets these requirements:
- In a PDB, to a value that is less than or equal to 50% of the value of SGA_TARGET in the PDB
- In a PDB, to a value that is less than or equal to 50% of the value of SGA_TARGET at the CDB level
- Across all the PDBs in a CDB, the sum of SGA_MIN_SIZE values must be less than or equal to 50% of the SGA_TARGET value at the CDB level.
When you set SGA_MIN_SIZE in a PDB to a value that does not meet these requirements, you receive an error. If these requirements are violated after the PDB’s parameter is set (for example, if the SGA_MIN_SIZE value is changed at the CDB level, Oracle will adjust the PDB’s value to meet these requirements.

Note:

This initialization parameter is available starting with Oracle Database 12c Release 2 (12.2.0.1).