The DBMS_DATA_DICT package controls data dictionary scheduling.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
Disable data dictionary scheduling
DBMS_DATA_DICT.DISABLE_DUMP(
unused_arg BINARY_INTEGER DEFAULT NULL);
Enable data dictionary scheduling
DBMS_DATA_DICT.ENABLE_DUMP(
unused_arg BINARY_INTEGER DEFAULT NULL);
Manually trigger dictionary generation
DBMS_DATA_DICT.TRIGGER_DUMP(
dict_item_retention_by_day BINARY_INTEGER DEFAULT NULL);
Adjust the scheduled DUMP interval of the dictionary
DBMS_DATA_DICT.MODIFY_DUMP_INTERVAL(
repeat_interval_expr IN VARCHAR2 DEFAULT NULL);
Adjust the retention interval for dictionary history records
DBMS_DATA_DICT.MODIFY_DICT_ITEM_RETENTION(
dict_item_retention_by_day BINARY_INTEGER DEFAULT NULL);
Adjust the maximum execution duration of dictionary DUMP tasks
DBMS_DATA_DICT.MODIFY_RUN_DURATION(
max_run_duration_by_sec BINARY_INTEGER DEFAULT NULL);
Parameters
Parameter |
Description |
Data type |
|---|---|---|
| unused_arg | Unused parameter. Reserved parameter. | BINARY_INTEGER |
| dict_item_retention_by_day | After dictionary generation is triggered, purge historical DUMP records of the dictionary:
|
BINARY_INTEGER |
| repeat_interval_expr | Specifies the desired scheduling interval. This parameter must follow the REPEAT_INTERVAL format of DBMS_SCHEDULER and be enclosed in single quotes. For example, 'FREQ=MINUTELY; INTERVAL=120'. |
VARCHAR2 |
| max_run_duration_by_sec | The maximum execution duration of a dictionary DUMP task, in seconds. | BINARY_INTEGER |
| dict_item_retention_by_day | The desired retention period for dictionary history records, in days. | BINARY_INTEGER |
Usage notes
- A data dictionary is automatically generated immediately after a tenant is created.
- Data dictionary generation is automatically triggered immediately after archiving is enabled.
Examples
Disable data dictionary scheduling
obclient> BEGIN
DBMS_DATA_DICT.DISABLE_DUMP();
END;
/
Enable data dictionary scheduling
obclient> BEGIN
DBMS_DATA_DICT.ENABLE_DUMP();
END;
/
Manually trigger dictionary generation
obclient> BEGIN
DBMS_DATA_DICT.TRIGGER_DUMP(7);
END;
/
Adjust the scheduled DUMP interval of the dictionary
obclient> BEGIN
DBMS_DATA_DICT.MODIFY_DUMP_INTERVAL('FREQ=MINUTELY; INTERVAL=120');
END;
/
Adjust the retention interval for dictionary history records
obclient> BEGIN
DBMS_DATA_DICT.MODIFY_DICT_ITEM_RETENTION(7);
END;
/
Adjust the maximum execution duration of dictionary DUMP tasks
obclient> BEGIN
DBMS_DATA_DICT.MODIFY_RUN_DURATION(3600);
END;
/