MEMORY_MAX_SIZE

MEMORY_MAX_SIZE specifies the maximum value to which a DBA can set the MEMORY_SIZE initialization parameter.

Property Description
Parameter type Big integer
Syntax

MEMORY_MAX_SIZE = integer [K | M | G]

Default value The value of the MEMORY_SIZE initialization parameter
Modifiable No
Modifiable in a PDB No
Range of values MEMORY_SIZE to the physical memory size available to the Oracle database
Basic No
Oracle RAC Different instances can use different values.

Note: This parameter is available starting with Oracle AI Database 26ai.

See Also: “MEMORY_SIZE” for more information about how the settings of MEMORY_MAX_SIZE and MEMORY_SIZE affect each other