Purpose
This view displays the major compaction information of the tenant.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| FROZEN_SCN | NUMBER(38) | NO | The version number of the last major compaction. |
| GLOBAL_BROADCAST_SCN | NUMBER(38) | NO | The time when the last major compaction was initiated (the value of FROZEN_SCN in a human-readable format). |
| LAST_SCN | NUMBER(38) | NO | The version number of the last completed major compaction. |
| LAST_FINISH_TIME | NUMBER(38) | NO | The time when the last major compaction was completed. |
| START_TIME | NUMBER(38) | NO | The start time of the major compaction. |
| STATUS | VARCHAR2(10) | NO | IDLE: No major compaction is in progress.COMPACTING: A major compaction is in progress.CHECKSUM: A checksum verification is in progress. |
| IS_ERROR | VARCHAR2(3) | NO | YES: An error occurred during the major compaction.NO: No error occurred during the major compaction. |
| IS_SUSPENDED | VARCHAR2(3) | NO | YES: The major compaction is suspended.NO: The major compaction is not suspended. |
| INFO | VARCHAR2(14) | NO | The major compaction information. For example, the reason why the major compaction failed. |