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