V$VECTOR_GRAPH_INDEX_SNAPSHOT
This fixed view provides diagnostic information about In-Memory Neighbor Graph vector index snapshots 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 |
VARCHAR(129) |
Index name |
INDEX_OBJN |
NUMBER |
Index object number |
SNAPSHOT_ID |
NUMBER |
Unique identifier for the snapshot |
FLAGS |
NUMBER |
State of the snapshot, used for debugging |
BUILD_SCN |
NUMBER |
The SCN at which the snapshot was built |
VALID_SCN |
NUMBER |
The SCN at which the snapshot is open for queries |
REFCOUNT |
NUMBER |
Number of active readers using the snapshot |
NUM_LAYERS |
NUMBER |
Number of graph layers for this snapshot |
NUM_VECTORS |
NUMBER |
Number of vectors currently present in the graph for the snapshot |
NUM_DELETES |
NUMBER |
Number of vertices marked as deleted in the graph for the snapshot |
START_VERTEX_ID |
NUMBER |
Starting vertex ID for the snapshot |
MAX_VERTEX_ID |
NUMBER |
Maximum vertex ID for the snapshot |
AVG_QUERY_DIST_COUNT |
NUMBER |
Average number of distance computations performed as part of queries that used the snapshot |
CREATION_DIST_COUNT |
NUMBER |
Number of distance computations performed as part of the In-Memory Neighbor Graph index creation |
SNAPSHOT_SIZE |
NUMBER |
The additional number of bytes that were used in the vector pool to host this snapshot. |
ALLOC_BYTES |
NUMBER |
The additional amount of memory, spanning all previous snapshots, that has been allocated from the vector pool, in bytes. |
USED_BYTES |
NUMBER |
Total amount of memory, spanning all previous snapshots, that is currently being used from the vector pool, in bytes |
MIN_DELETE_SCN |
NUMBER |
Minimum SCN at which a delete happened for the snapshot |
MIN_INSERT_SCN |
NUMBER |
Minimum SCN at which an insert happened the snapshot |
CON_ID |
NUMBER |
The ID of the container to which the data pertains. Possible values include:
|