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] (default RESTART)

  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 HNSW RAC Duplication.

• VECTOR_QUERY_CAPTURE

  Syntax: VECTOR_QUERY_CAPTURE = [ON | OFF] (default ON)

  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 AI Database 26ai Release Updates.

  For more information about this parameter, see Oracle AI Database Reference.