Feature
DBA_OB_ZONE_MAJOR_COMPACTION displays information about the major compactions of zones.
Fields
| Field | 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 | IDLE: not in major compactionCOMPACTION: in major compactionCHECKSUM: checksum checking |