First page Back Continue Last page Graphics
SGA_MAX_SIZE…
Determines the maximum overall size limit of the SGA
Careful- reserves memory on most OS’
Cannot be dynamically altered
Recommended to explicitly set in init.ora
- Defaults to the total size of the SGA at an instance startup if it is not set
Notes:
There is a limit on how large the SGA can grow to. It is set by the SGA_MAX_SIZE initialization parameter. The default value of the SGA_MAX_SIZE parameter is the total size of the SGA at an instance startup.
SGA_MAX_SIZE cannot be dynamically altered.
If SGA_MAX_SIZE has been set to a value smaller than the amount of memory needed for the SGA or if the SGA_MAX_SIZE has not been set, then the value of SGA_MAX_SIZE will default to the total size of the SGA at an instance startup. This would prevent you from taking advantage of the dynamic SGA resizing features as your SGA would have no room to grow.
Setting SGA_MAX_SIZE will cause Oracle to reserve this memory on most operating systems.