Note
- Due to the optimized storage architecture in V4.x, this view is available starting with V4.0.0.
- In V4.x, for Mini Compaction (dump), since there are no clear start and end times, you cannot query Checkpoint information. For Major Compaction (merge), the system tenant can query Checkpoint information for each tenant using the view CDB_OB_MAJOR_COMPACTION, and the user tenant can query Checkpoint information for its own tenant using the view DBA_OB_MAJOR_COMPACTION.
Purpose
CDB_CKPT_HISTORY displays the Checkpoint information for each tenant in the system, including the type, version number, cluster version, and start and end times.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(32) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| TENANT_ID | varchar(256) | NO | The tenant ID. |
| CHECKPOINT_SNAPSHOT | longtext | NO | The snapshot version number at which the Checkpoint was written. |
| CHECKPOINT_TYPE | varchar(256) | NO | The type of the Checkpoint:
|
| CHECKPOINT_CLUSTER_VERSION | varchar(256) | NO | The version number of the OceanBase cluster at which the Checkpoint was written. |
| START_TIME | timestamp(6) | NO | The start time at which the Checkpoint was written. |
| FINISH_TIME | varchar(32) | NO | The end time at which the Checkpoint was written. |