1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. INMEMORY_FORCE

1.141 INMEMORY_FORCE

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

Property Description

Parameter type

String

Syntax

INMEMORY_FORCE = { DEFAULT | OFF }

Default value

DEFAULT

Modifiable

ALTER SYSTEM

Modifiable in a PDB

Yes

Basic

No

Oracle RAC

All instances should use the same value.

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.

See Also: