Purpose
The oceanbase.CDB_OB_ZONE_MAJOR_COMPACTION view displays the major compaction information of each zone in all tenants under the sys tenant.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| ZONE | varchar(128) | NO | The name of the zone. |
| BROADCAST_SCN | bigint(20) unsigned | NO | The major compaction version that is broadcast. |
| LAST_SCN | bigint(20) unsigned | NO | The version number of the last major compaction. |
| LAST_FINISH_TIME | timestamp(6) | NO | The time when the last major compaction was completed. |
| START_TIME | timestamp(6) | NO | The time when the major compaction started. |
| STATUS | varchar(10) | NO |
|