DBMS_DATA_DICT

DBMS_DATA_DICT is used to control the scheduling of the data dictionary.

Syntax

Disable scheduling of the data dictionary

DBMS_DATA_DICT.DISABLE_DUMP(
    unused_arg BINARY_INTEGER DEFAULT NULL);

Enable scheduling of the data dictionary

DBMS_DATA_DICT.ENABLE_DUMP(
    unused_arg BINARY_INTEGER DEFAULT NULL);

Manually trigger the generation of the data dictionary

DBMS_DATA_DICT.TRIGGER_DUMP(
    dict_item_retention_by_day BINARY_INTEGER DEFAULT NULL);

Adjust the scheduled DUMP cycle of the data dictionary

DBMS_DATA_DICT.MODIFY_DUMP_INTERVAL(
    repeat_interval_expr IN VARCHAR2 DEFAULT NULL);

Adjust the retention interval of data 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 data dictionary DUMP tasks

DBMS_DATA_DICT.MODIFY_RUN_DURATION(
    max_run_duration_by_sec BINARY_INTEGER DEFAULT NULL);

Parameters

Usage notes

• A data dictionary is automatically generated immediately after a tenant is created.
• A data dictionary is automatically generated immediately when log archiving is enabled.

Examples

Disable scheduling of the data dictionary

obclient> BEGIN
  DBMS_DATA_DICT.DISABLE_DUMP();
END;
/

Enable scheduling of the data dictionary

obclient> BEGIN
  DBMS_DATA_DICT.ENABLE_DUMP();
END;
/

Manually trigger the generation of the data dictionary

obclient> BEGIN
  DBMS_DATA_DICT.TRIGGER_DUMP(7);
END;
/

Adjust the scheduled DUMP cycle of the data dictionary

obclient> BEGIN
  DBMS_DATA_DICT.MODIFY_DUMP_INTERVAL('FREQ=MINUTELY; INTERVAL=120');
END;
/

Adjust the retention interval of data dictionary history records

obclient> BEGIN
  DBMS_DATA_DICT.MODIFY_DICT_ITEM_RETENTION(7);
END;
/

Adjust the maximum execution duration of data dictionary DUMP tasks

obclient> BEGIN
  DBMS_DATA_DICT.MODIFY_RUN_DURATION(3600);
END;
/