Purpose
The oceanbase.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.
Note
This view is introduced since OceanBase Database V4.2.0.
Related parameters
dump_data_dictionary_to_log_interval
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SNAPSHOT_SCN | bigint(20) unsigned | NO | The snapshot SCN of the tenant when the data dictionary was generated. |
| REPORT_TIME | timestamp(6) | YES | The time when the data dictionary was reported to the internal table, in microseconds. |
| START_LSN | bigint(20) unsigned | 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 | bigint(20) unsigned | NO | The LSN of the last log when the data dictionary was persisted in the log stream with the ID 1 of the tenant. |