oceanbase.CDB_OB_DATA_DICTIONARY_IN_LOG

2024-04-19 08:42:49  Updated

Purpose

The oceanbase.CDB_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.

dump_data_dictionary_to_log_interval

Columns

Column Type Nullable? Description
TENANT_ID bigint(20) NO The ID of the tenant. Valid values:
  • 1: the sys tenant.
  • Other values: a user tenant.
SNAPSHOT_SCN bigint(20) unsigned NO The snapshot SCN of the tenant when the data dictionary was generated.
REPORT_TIME timestamp(6) NO 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.

Contact Us