Overview
Displays the major compaction information for each zone in the tenant.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| ZONE | varchar(128) | NO | Zone Name |
| BROADCAST_SCN | bigint(20) unsigned | NO | Broadcast Major Compaction Version Number |
| LAST_SCN | bigint(20) unsigned | NO | The version number of the last major compaction |
| LAST_FINISH_TIME | timestamp(6) | NO | Last Major Compaction End Time |
| START_TIME | timestamp(6) | NO | Start Time of Major Compaction |
| STATUS | varchar(10) | NO |
|
Sample query
The system tenant can view the major compaction information for each zone in the current tenant.
obclient> SELECT * FROM oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION;
The query result is as follows:
+-------+---------------------+---------------------+----------------------------+----------------------------+--------+
| ZONE | BROADCAST_SCN | LAST_SCN | LAST_FINISH_TIME | START_TIME | STATUS |
+-------+---------------------+---------------------+----------------------------+----------------------------+--------+
| zone1 | 1748455203800778000 | 1748455203800778000 | 2025-05-29 02:08:07.213120 | 2025-05-29 02:00:03.843129 | IDLE |
+-------+---------------------+---------------------+----------------------------+----------------------------+--------+
1 row in set
References
View the global major compaction information of the tenant: DBA_OB_MAJOR_COMPACTION
View basic statistics on tablet-level major compactions:
View detailed historical information on tablet-level major compactions:
For more information about major compaction, see the following topics: