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: