Purpose
The oceanbase.DBA_OB_ZONE_MAJOR_COMPACTION view displays information about the major compactions of zones.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| 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 | IDLE: not in major compactionCOMPACTION: in major compactionCHECKSUM: checksum checking |