V$VECTOR_GRAPH_INDEX_CHKPT

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

Column Name Data Type Description
INDEX_OBJN NUMBER Index object number
CHECKPOINT_ID NUMBER Unique identifier for the checkpoint
CHECKPOINT_SCN NUMBER The 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