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 |
|
| 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 AI Database 26ai.