Overview
dump_data_dictionary_to_log_interval specifies the interval for persisting tenant data dictionaries.
Privilege requirements
Query parameters
The
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Both the
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | Time |
| Default Value | 0. The default unit is seconds.
NoteWhen the value is 0, the data dictionary will not be generated through scheduling based on this parameter. To stop generating the data dictionary, you need to use it together with |
| Value range | [0s, +∞) |
| Modifiable | Yes, you can use the following methods:ALTER SYSTEM SETStatement modification. |
| Whether to Restart the OBServer Node for the Change to Take Effect | No, the setting takes effect immediately. |
Usage instructions
The data dictionary serves only user tenants and is persisted in the system log stream (SYS_LS) of a regular tenant via PALF. After a user tenant is created, the data dictionary service is automatically enabled and runs on the LEADER replica of the tenant's SYS_LS.
When the log archiving service is enabled, an asynchronous data dictionary generation task is automatically triggered. OceanBase AI Database supports scheduled data dictionary generation through the tenant-level parameter dump_data_dictionary_to_log_interval and the DBMS_DATA_DICT system package. It is recommended to schedule data dictionary generation using the DBMS_DATA_DICT system package.
OceanBase AI Database supports recording data dictionary generation records through DBA/CDB views. You can query the CDB_OB_DATA_DICTIONARY_IN_LOG view in the sys tenant, or the DBA_OB_DATA_DICTIONARY_IN_LOG view in a user tenant to obtain dictionary location information.
Configuration example
Set the tenant data dictionary persistence cycle to 24H.
obclient> ALTER SYSTEM SET dump_data_dictionary_to_log_interval = '24H';
References
For more information about data dictionaries, see Data dictionary support in obcdc.
For more information about log archiving, see the Log Archiving section.