Overview
Records the location range of the data dictionary in the system log stream to facilitate CDC consumption of the data dictionary.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| SNAPSHOT_SCN | bigint(20) unsigned | NO | SNAPSHOT SCN of the corresponding tenant during data dictionary generation |
| REPORT_TIME | timestamp(6) | YES | Time taken to report the generated data dictionary to the internal table (in microseconds) |
| START_LSN | bigint(20) unsigned | NO | LSN of the first log persisted in tenant log stream 1 |
| END_LSN | bigint(20) unsigned | NO | LSN of the last log persisted in tenant log stream 1 |
Sample query
View the location range of this tenant's data dictionary in the system log stream.
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