Note
This view is available starting with V4.0.0.
Purpose
This view displays the global information of the current tenant.
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 version number of the global broadcast major compaction. |
| LAST_SCN | NUMBER(38) | NO | The version number of the last major compaction that was completed. |
| LAST_FINISH_TIME | NUMBER(38) | NO | The end time of the last major compaction. |
| START_TIME | NUMBER(38) | NO | The start time of the major compaction. |
| STATUS | VARCHAR2(10) | NO |
|
| IS_ERROR | VARCHAR2(3) | NO |
|
| IS_SUSPENDED | VARCHAR2(3) | NO |
|
| INFO | VARCHAR2(14) | NO | The information about the major compaction. For example, the reason for the major compaction failure. |
| MODE | VARCHAR2(7) | NO | The type of the daily major compaction:
NoteThis column is available starting with V4.6.0. |
Sample query
Query the global information of the current tenant.
obclient(SYS@oracle001)[SYS]> SELECT * FROM SYS.DBA_OB_MAJOR_COMPACTION;
The query result is as follows:
+---------------------+----------------------+---------------------+------------------+------------------+--------+----------+--------------+------+--------+
| FROZEN_SCN | GLOBAL_BROADCAST_SCN | LAST_SCN | LAST_FINISH_TIME | START_TIME | STATUS | IS_ERROR | IS_SUSPENDED | INFO | MODE |
+---------------------+----------------------+---------------------+------------------+------------------+--------+----------+--------------+------+--------+
| 1772647200462679000 | 1772647200462679000 | 1772647200462679000 | 1772647531394359 | 1773049642612055 | IDLE | NO | NO | NULL | WINDOW |
+---------------------+----------------------+---------------------+------------------+------------------+--------+----------+--------------+------+--------+
1 row in set
References
Query the global information of the current tenant in each zone: DBA_OB_ZONE_MAJOR_COMPACTION
Query the detailed history of tablet-level major compactions:
For more information about major compaction operations, see the following topics: