1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. INMEMORY_DEEP_VECTORIZATION

2.152 INMEMORY_DEEP_VECTORIZATION

INMEMORY_DEEP_VECTORIZATION enables or disables the deep vectorization framework.

Property Description

Parameter type

Boolean

Default value

TRUE

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

Yes

Range of values

TRUE | FALSE

Basic

No

Deep vectorization can optimize complex SQL operations (such as joins) by pipelining physical operators inside each SQL operator and vectorizing them.

Note:

This parameter is available starting with Oracle Database 21c.

See Also:

Oracle Database In-Memory Guide for information about deep vectorization