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