V$VECTOR_GRAPH_INDEX
V$VECTOR_GRAPH_INDEX displays diagnostic information about In-Memory Neighbor Graph vector indexes.
This view is populated only on Oracle Autonomous AI Database Serverless (ADB-S).
| Column | Datatype | Description |
|---|---|---|
OWNER |
VARCHAR2(129) |
Owner of the index |
INDEX_NAME |
VARCHAR2(129) |
Name of the index |
PARTITION_NAME |
VARCHAR2(129) |
Object partition name The value of this column is null for non-partitioned objects. |
INDEX_OBJN |
NUMBER |
Index object number |
ANCHOR_ADDRESS |
RAW(8) |
Address of the anchor structure for the vector in the vector pool |
INDEX_GRAPH_TYPE |
VARCHAR2(129) |
Type of the constructed graph of the index The value of this column is always |
NUM_LAYERS |
NUMBER |
Number of layers in the constructed graph |
NUM_VECTORS |
NUMBER |
Number of indexed vectors in the index |
SPARSE_LAYER_VECTORS |
NUMBER |
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 index Note that an index can only be dropped when the value of this column is 0. |
QUERY_DIST_COUNT |
NUMBER |
Number of distance computations performed as part of queries that used the index |
CREATION_DIST_COUNT |
NUMBER |
Number of distance computations performed as part of index creation |
PRUNED_NEIGHBORS |
NUMBER |
Number of neighbors pruned out during the neighbor selection phase of index creation |
NUM_SNAPSHOTS |
NUMBER |
Number of snapshots currently tracked for the index |
MAX_SNAPSHOT |
NUMBER |
Number of snapshots created for the index |
ALLOCATED_BYTES |
NUMBER |
Total amount of memory allocated to the index (in bytes) |
USED_BYTES |
NUMBER |
Total amount of memory currently used by the index (in bytes) |
INDEX_USED_COUNTFoot 1 |
NUMBER |
Number of times the index has been used by queries |
COVERING_COLSFoot 2 |
VARCHAR2(3999) |
Comma-separated list of included columns for the index |
QUANTIZATION_TYPEFoot 3 |
VARCHAR2(129) |
Indicates whether the index is a scalar quantized HNSW index (SCALAR) or not (NONE) |
QUANTIZATION_MDATAFoot 3 |
JSON |
For scalar quantized HNSW indexes, the quantization metadata, in JSON format. Otherwise, null. |
CON_ID |
NUMBER |
The ID of the container to which the data pertains. Possible values include:
|
Footnote 1 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.2.
Footnote 2 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.1.
Footnote 3 This column is available starting with Oracle AI Database 26ai, Release Update 23.26.3.
Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.6.