MEMOPTIMIZE_WRITES

MEMOPTIMIZE_WRITES allows you to instruct the database to always use fast ingest when inserting data into tables enabled for Memoptimized Rowstore fast ingest.

Property	Description
Parameter type	String
Syntax	MEMOPTIMIZE_WRITES = { HINT | ON }
Default value	HINT
Modifiable	ALTER SESSION
Modifiable in a PDB	No
Basic	No

The fast ingest feature of Memoptimized Rowstore was introduced in Oracle Database 19c. At that time, the only way to direct the database to use fast ingest was to specify the MEMOPTIMIZE_WRITE hint in the INSERT statement.

Starting with Oracle AI Database 26ai, you can also direct the database to use fast ingest by setting the MEMOPTIMIZE_WRITES initialization parameter as follows:

• ON - When inserting data into tables enabled for fast ingest, the fast ingest feature is always used, regardless of whether the MEMOPTIMIZE_WRITE hint is specified in the INSERT statement.

• HINT - When inserting data into tables enabled for fast ingest, the fast ingest feature is used only when the MEMOPTIMIZE_WRITE hint is specified in the INSERT statement.

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