2.231 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 Database 23ai.

See Also:

"MEMORY_SIZE" for more information about how the settings of MEMORY_MAX_SIZE and MEMORY_SIZE affect each other