INMEMORY_FORCE

Property Description

Parameter type

String

Syntax

INMEMORY_FORCE = { DEFAULT | OFF }

Default value

DEFAULT

Modifiable

ALTER SYSTEM

Basic

No

Oracle RAC

All instances should use the same value.

INMEMORY_FORCE allows you to specify whether tables and materialized view that are specified as INMEMORY are populated into the In-Memory Column Store (IM column store) or not.

The default value is DEFAULT. When this value is in effect, the IM column store is populated only with tables and materialized views specified as INMEMORY.

If OFF is specified, then even if the IM column store is configured on this instance, no tables or materialized are populated in memory.

Note:

This initialization parameter is available starting with Oracle Database 12c Release 1 (12.1.0.2).

See Also: