1.138 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 views are populated in memory.

See Also:

• "INMEMORY_CLAUSE_DEFAULT"

• "INMEMORY_MAX_POPULATE_SERVERS"

• "INMEMORY_QUERY"

• "INMEMORY_SIZE"

• Oracle Database In-Memory Guide for an introduction to the IM column store

• Oracle Database In-Memory Guide for more information about the IM column store