Note
This view is available starting with V4.2.0.
Purpose
This view records the location range of the data dictionary in the system log stream, facilitating data dictionary consumption by CDC.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SNAPSHOT_SCN | bigint(20) unsigned | NO | The SNAPSHOT SCN corresponding to the tenant at the time the data dictionary was generated. |
| REPORT_TIME | timestamp(6) | YES | The time when the data dictionary was generated and reported to the internal table. (Unit: microseconds) |
| START_LSN | bigint(20) unsigned | NO | The LSN of the first log in the tenant's primary log stream where the data dictionary is persisted. |
| END_LSN | bigint(20) unsigned | NO | The LSN of the last log in the tenant's primary log stream where the data dictionary is persisted. |
Sample query
Query the location range of the data dictionary in the system log stream for the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_DATA_DICTIONARY_IN_LOG;
The query result is as follows:
+---------------------+----------------------------+-----------+-----------+
| SNAPSHOT_SCN | REPORT_TIME | START_LSN | END_LSN |
+---------------------+----------------------------+-----------+-----------+
| 1723084121964378000 | 2024-08-08 10:28:42.014127 | 10713062 | 10713062 |
| 1723170522400303000 | 2024-08-09 10:28:42.439283 | 139661239 | 139661239 |
+---------------------+----------------------------+-----------+-----------+
2 rows in set