INMEMORY_QUERY

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

INMEMORY_QUERY is used to enable or disable in-memory queries for the entire database at the session or system level. 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.

Note:

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

See Also: