2.226 MEMOPTIMIZE_WRITE_AREA_SIZE

MEMOPTIMIZE_WRITE_AREA_SIZE specifies the size of the ingest buffer in the large pool of the SGA. The ingest buffer is where Memoptimized Rowstore fast ingest inserts are buffered.

Property	Description
Parameter type	Big integer
Syntax	MEMOPTIMIZE_WRITE_AREA_SIZE = integer [K | M | G]
Default value	0
Modifiable	ALTER SYSTEM ... SID='*'
Modifiable in a PDB	No
Range of values	0 to operating system-dependent
Basic	No
Oracle RAC	You must set this parameter for every instance, and multiple instances must have the same value.

Note:

This parameter is available starting with Oracle Database 23ai.