Note
This view was introduced in OceanBase Database V4.2.0.
Purpose
The DBA_OB_DATA_DICTIONARY_IN_LOG view displays the location range of data dictionaries in the system log stream so that Change Data Capture (CDC) can conveniently consume the data dictionaries.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SNAPSHOT_SCN | NUMBER(38) | NO | The snapshot system change number (SCN) of the tenant when the data dictionary was generated. |
| REPORT_TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the data dictionary was reported to the internal table, in µs. |
| START_LSN | NUMBER(38) | NO | The LSN of the first log when the data dictionary was persisted in the log stream with the ID 1 of the tenant. |
| END_LSN | NUMBER(38) | NO | The LSN of the last log when the data dictionary was persisted in the log stream with the ID 1 of the tenant. |
Sample query
Query the location range of data dictionaries of the current tenant in the system log stream.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_DATA_DICTIONARY_IN_LOG;
The query result is as follows:
+---------------------+------------------------------+-----------+-----------+
| SNAPSHOT_SCN | REPORT_TIME | START_LSN | END_LSN |
+---------------------+------------------------------+-----------+-----------+
| 1723084155932969000 | 08-AUG-24 10.29.15.983581 AM | 16136726 | 16136726 |
| 1723170556335749000 | 09-AUG-24 10.29.16.366229 AM | 148555952 | 148555952 |
+---------------------+------------------------------+-----------+-----------+
2 rows in set