2.229 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.