10.152 V$VECTOR_GRAPH_INDEX_CHKPT

V$VECTOR_GRAPH_INDEX_CHKPT displays diagnostic information about In-Memory Neighbor Graph vector index disk checkpoints.

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

Column Datatype Description

INDEX_OBJN

NUMBER

Index object number

CHECKPOINT_ID

NUMBER

Unique identifier for the checkpoint

CHECKPOINT_SCN

NUMBER

SCN at which the checkpoint was created

CHECKPOINT_TYPE

NUMBER

Indicates whether the checkpoint is a full checkpoint or incremental checkpoint

The value of this column is always 1, which indicates a full checkpoint.

VERSION_NUMBER

NUMBER

Version number for the checkpoint

TABLESPACE_NUMBER

NUMBER

TSN for the tablespace storing the checkpoint

NUM_VECTORS

NUMBER

Number of vectors currently present in the checkpoint

NUM_DELETES

NUMBER

Number of vertices marked as deleted in the checkpoint graph

MAX_VERTEX_ID

NUMBER

Maximum vertex ID for the checkpoint

NUM_LAYERS

NUMBER

Number of graph layers in the checkpoint

NUM_COMPONENTS

NUMBER

Number of subcomponents in the multi-layered graph checkpoint

This value can be used to track the multiple BLOBs into which the graph checkpoint is divided.

CHECKPOINT_SIZE

NUMBER

Total size of the checkpoint, including serialized BLOBs for each graph layer (in bytes)

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.