2.167 INMEMORY_OPTIMIZED_DATE

Use INMEMORY_OPTIMIZED_DATE to enable or disable the In-Memory Optimized Dates feature.

Property	Description
Parameter type	String
Syntax	INMEMORY_OPTIMIZED_DATE = { ENABLE | DISABLE }
Default value	DISABLE
Modifiable	ALTER SESSION, ALTER SYSTEM
Modifiable in a PDB	Yes
Basic	No
Oracle RAC	Different instances can use different values.

When this parameter is set to ENABLE, In-Memory can run date-based analytic queries much faster by leveraging the In-Memory Expressions framework.

Note:

This parameter is available starting with Oracle Database 23ai.

See Also:

Oracle Database In-Memory Guide for more information about the In-Memory Optimized Dates feature