Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
The oceanbase.CDB_OB_MAJOR_COMPACTION view displays the global major compaction information of all tenants in the sys tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| FROZEN_SCN | bigint(20) unsigned | NO | The version number of the last major compaction. |
| FROZEN_TIME | timestamp(6) | NO | The time when the last major compaction was initiated. The value of FROZEN_SCN is displayed in an intelligible format. |
| GLOBAL_BROADCAST_SCN | bigint(20) unsigned | NO | The major compaction version that is globally broadcast. |
| LAST_SCN | bigint(20) unsigned | NO | The version 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 | The major compaction status. Valid values:IDLE: No major compaction is in progress.COMPACTION: A major compaction is in progress.CHECKSUM: The checksum is being verified. |
| IS_ERROR | varchar(3) | NO | Indicates whether an error occurred during the major compaction. Valid values:YESNO |
| IS_SUSPENDED | varchar(3) | NO | Indicates whether the major compaction is suspended. Valid values:YESNO |
| INFO | varchar(14) | NO | The major compaction information, for example, the reason for the major compaction failure. |