Note
This view is introduced in OceanBase Database V4.0.0.
Purpose
This view displays the information about the versions generated during major compactions in the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| FROZEN_SCN | bigint(20) unsigned | NO | The version number of the major compaction. |
| CLUSTER_VERSION | bigint(20) | NO | The cluster version at the time of the major compaction. |
| SCHEMA_VERSION | bigint(20) | NO | The schema version at the time of the major compaction. |
| GMT_CREATE | timestamp(6) | NO | The creation time of the record. |
| GMT_MODIFIED | timestamp(6) | NO | The last modification time of the record. |
Sample query
Query the information about the versions generated during major compactions in the current user tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_FREEZE_INFO;
The query result is as follows:
+---------------------+-----------------+------------------+----------------------------+----------------------------+
| FROZEN_SCN | CLUSTER_VERSION | SCHEMA_VERSION | GMT_CREATE | GMT_MODIFIED |
+---------------------+-----------------+------------------+----------------------------+----------------------------+
| 1 | 17180001538 | 1 | 2025-01-06 16:33:40.282597 | 2025-01-06 16:33:40.282597 |
| 1736186400347403000 | 17180001538 | 1736159809268152 | 2025-01-07 02:00:00.349916 | 2025-01-07 02:00:00.349916 |
| 1736272801782123000 | 17180001538 | 1736237493480448 | 2025-01-08 02:00:01.783827 | 2025-01-08 02:00:01.783827 |
| 1736359203243332000 | 17180001538 | 1736317182153936 | 2025-01-09 02:00:03.246213 | 2025-01-09 02:00:03.246213 |
+---------------------+-----------------+------------------+----------------------------+----------------------------+
4 rows in set