Oracle AI Vector Search Parameters
This is a set of parameters related to Oracle AI Vector Search.
-
VECTOR_MEMORY_SIZE
Syntax:
VECTOR_MEMORY_SIZE = integer[K | M | G]
The initialization parameter
VECTOR_MEMORY_SIZE
specifies either the current size of the Vector Pool (at CDB level) or the maximum Vector Pool usage allowed by a PDB (at PDB level).For more information about this parameter, see Size the Vector Pool.
-
VECTOR_INDEX_NEIGHBOR_GRAPH_RELOAD
Syntax:
VECTOR_INDEX_NEIGHBOR_GRAPH_RELOAD = [RESTART | OFF]
(defaultRESTART
)The initialization parameter
VECTOR_INDEX_NEIGHBOR_GRAPH_RELOAD
is used to manage automatic recreation of HNSW indexes. You can enable or disable both the HNSW duplication and reload mechanisms in Oracle RAC and non-RAC environments.For more information about this parameter and the duplication and reload mechanisms, see Understand HNSW Index Population Mechanisms in Oracle RAC or Single Instance.
-
VECTOR_QUERY_CAPTURE
Syntax:
VECTOR_QUERY_CAPTURE = [ON | OFF]
(defaultON
)The initialization parameter
VECTOR_QUERY_CAPTURE
is used to enable or disable capture of query vectors.For more information about this parameter and about capturing query vectors, see Index Accuracy Report.
-
COMPATIBLE
Syntax:
COMPATIBLE = release_number
The initialization parameter enables you to use a new release of Oracle while ensuring the ability to downgrade the database to an earlier release. To use the
VECTOR
data type and its related features,COMPATIBLE
must be set to 23.4.0 or higher.Certain vector features require the
COMPATIBLE
parameter to be manually updated to a higher value in order to be available for use. To find requirements for a particular feature, see the applicable Release Update page at Oracle Database 23ai Release Updates.For more information about this parameter, see Oracle Database Reference.
Parent topic: Vector Diagnostics