INMEMORY_QUERY

INMEMORY_QUERY is used to enable or disable in-memory queries for the entire database at the session or system level.

Property	Description
Parameter type	String
Syntax	INMEMORY_QUERY = { ENABLE | DISABLE }
Default value	ENABLE
Modifiable	ALTER SESSION, ALTER SYSTEM
Modifiable in a PDB	Yes
Basic	No
Oracle RAC	All instances should use the same value.

This parameter is helpful when you want to test workloads with and without the use of the In-Memory Column Store (IM column store).

This parameter enables in-memory queries for the entire database by default when the INMEMORY_SIZE parameter is specified.

Set this parameter to DISABLE if you want to disable in-memory queries.

See Also:

• “INMEMORY_CLAUSE_DEFAULT”

• “INMEMORY_FORCE”

• “INMEMORY_MAX_POPULATE_SERVERS”

• “INMEMORY_SIZE”

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

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