2.168 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 |
|
Default value |
|
Modifiable |
|
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:
-
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