Note
This view is available starting with V4.2.0.
Purpose
This view records the range of the data dictionary in the system log stream, facilitating CDC consumption of the data dictionary.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SNAPSHOT_SCN | NUMBER(38) | NO | The SNAPSHOT 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 generated and reported to the internal table. (Unit: microseconds) |
| START_LSN | NUMBER(38) | NO | The LSN of the first log in the tenant's primary log stream where the data dictionary is persisted. |
| END_LSN | NUMBER(38) | NO | The LSN of the last log in the tenant's primary log stream where the data dictionary is persisted. |
Sample query
Query the range of the data dictionary in the system log stream for the current tenant.
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