2.168 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