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 Understand HNSW Index Population Mechanisms in Oracle RAC or Single Instance.

  • 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 Database 23ai Release Updates.

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