10.153 V$VECTOR_GRAPH_INDEX_SNAPSHOT

V$VECTOR_GRAPH_INDEX_SNAPSHOT diagnostic information about In-Memory Neighbor Graph vector indexes snapshots.

This view is populated only on Oracle Autonomous Database Serverless (ADB-S).

Column Datatype Description

OWNER

VARCHAR2(129)

User name of the vector graph index owner

INDEX_NAME

VARCHAR2(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

SCN at which the snapshot was built

VALID_SCN

NUMBER

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 for the snapshot

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire 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

Note:

This view is available starting with Oracle Database 23ai, Release Update 23.9.