Note
- Due to the storage architecture optimization of OceanBase Database V4.x, this view has been deprecated since OceanBase Database V4.0.0.
- In OceanBase Database V4.x, you cannot query the checkpoint information of minor compactions because their start time and end time are not specified. However, you can query the checkpoint information of major compactions. For example, you can query the CDB_OB_MAJOR_COMPACTION view in the
systenant for the checkpoint information of all tenants, or query the DBA_OB_MAJOR_COMPACTION view in a user tenant for its checkpoint information.
Purpose
The oceanbase.CDB_CKPT_HISTORY view displays the information about the execution of checkpoints by each tenant in the system, including the type, version number, cluster version, start time, and end time of each checkpoint.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | varchar(32) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| TENANT_ID | varchar(256) | NO | The ID of the tenant. |
| CHECKPOINT_SNAPSHOT | longtext | NO | The snapshot version number of the data written to the checkpoint. |
| CHECKPOINT_TYPE | varchar(256) | NO | The type of the checkpoint. Valid values: META_CKPT: indicates a checkpoint for a major compaction.DATA_CKPT: indicates a checkpoint for a minor compaction. |
| CHECKPOINT_CLUSTER_VERSION | varchar(256) | NO | The version number of the OceanBase cluster that wrote data to the checkpoint. |
| START_TIME | timestamp(6) | NO | The start time of data writing to the checkpoint. |
| FINISH_TIME | varchar(32) | NO | The end time of data writing to the checkpoint. |