6 июля 2011 г.

oracle: sga_max_size

SGA_MAX_SIZE

Property Description
Parameter type Big integer
Syntax SGA_MAX_SIZE = integer [K | M | G]
Default value Initial size of SGA at startup, dependent on the sizes of different pools in the SGA, such as buffer cache, shared pool, large pool, and so on.
Modifiable No
Range of values 0 to operating system-dependent
SGA_MAX_SIZE specifies the maximum size of the SGA for the lifetime of the instance.