Purpose
The DBA_OB_ZONE_MAJOR_COMPACTION view provides information about the major compactions of zones.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| ZONE | VARCHAR2(128) | NO | The name of the zone. |
| BROADCAST_SCN | NUMBER(38) | NO | The major compaction version that is broadcast. |
| LAST_SCN | NUMBER(38) | NO | The version number of the last major compaction. |
| LAST_FINISH_TIME | NUMBER(38) | NO | The time when the last major compaction was completed. |
| START_TIME | NUMBER(38) | NO | The time when the major compaction started. |
| STATUS | VARCHAR2(10) | NO |
|