V$VECTOR_GRAPH_INDEX

The script content on this page is for navigation purposes only and does not alter the content in any way.

This fixed view provides diagnostic information about In-Memory Neighbor Graph vector indexes and is available with Autonomous AI Database Serverless (ADB-S).

Column Name	Data Type	Description
`OWNER`	`VARCHAR2(129)`	User name of the vector graph index owner
`INDEX_NAME`	`VARCHAR2(129)`	Name of the vector graph index
`PARTITION_NAME`	`VARCHAR2(129)`	Object partition name (set to `NULL` for non-partitioned objects)
`INDEX_OBJN`	`NUMBER`	Index object number
`ANCHOR_ADDRESS`	`RAW(8)`	The address of the anchor structure of the in-memory neighbor graph index in the vector pool
`INDEX_GRAPH_TYPE`	`VARCHAR2(129)`	Type of the constructed graph of this index. Possible values: `HNSW`: Hierarchical Navigable Small Worlds. Currently only this graph is supported. `DISTRIBUTED_HNSW [AUTO/ROWID_RANGE/PARTITION/SUBPARTITION]`
`NUM_LAYERS`	`NUMBER`	Number of layers in the constructed graph
`NUM_VECTORS`	`NUMBER`	Number of indexed vectors in the vector graph index
`SPARSE_LAYER_VECTORS`	`NUMBER`	The total number of vectors in the sparse layers. Note that a sparse layer is defined as any layer above the bottom most layer.
`NUM_NEIGHBORS`	`NUMBER`	Maximum number of neighbors a vector can have in the sparse layers
`EF_CONSTRUCTION`	`NUMBER`	Maximum number of closest vector candidates considered at each step of the search during insertion
`TOTAL_EDGES`	`NUMBER`	Number of total edges in the constructed graph as of the latest snapshot
`REF_COUNT`	`NUMBER`	Number used to track readers of the inmemory neighbor graph index. The inmemory neighbor graph index can only be dropped once the `refcount` is 0.
`QUERY_DIST_COUNT`	`NUMBER`	Number of distance computations done as part of queries that used the inmemory neighbor graph index
`CREATION_DIST_COUNT`	`NUMBER`	Number of distance computations done as part of the inmemory neighbor graph index creation
`PRUNED_NEIGHBORS`	`NUMBER`	Number of neighbors pruned out during the neighbor selection phase of the inmemory neighbor graph index creation
`NUM_SNAPSHOTS`	`NUMBER`	Number of snapshots currently tracked for the inmemory neighbor graph index
`MAX_SNAPSHOT`	`NUMBER`	The total number of snapshots created so far for the inmemory graph index
`ALLOCATED_BYTES`	`NUMBER`	Total amount of memory allocated to this vector graph index, in bytes
`USED_BYTES`	`NUMBER`	Total amount of memory currently used by the vector graph index, in bytes
`COVERING_COLS` Foot 1	`VARCHAR2(3999)`	Comma-separated list of included columns for the index.
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include the following: `0`: This value is used for rows containing data that pertain to the entire multitenant container database (CDB). This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root `n`: Where `n` is the applicable container ID for the rows containing data

Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.1.