MODIFY_SNAPSHOT_SETTINGS|V4.3.5|OceanBase Database| docs|Distributed Database

| tenant-type | MySQL Mode |

The MODIFY_SNAPSHOT_SETTINGS procedure is used to modify the WORKLOAD_REPOSITORY settings and is available only to the SYS tenant.

Syntax

DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(
   retention          INT    DEFAULT  NULL,
   interval           INT    DEFAULT  NULL);

Parameter	Description
retention	The retention time for a snapshot. Snapshots exceeding this time will be automatically deleted. The unit is minutes. The value range is [1440 minutes (1 day), 52560000 minutes (100 years)]. If the value is set to 0, it means permanent retention, and the retention time will be set to 57816000 minutes (110 years). If the value is set to NULL, the original retention time will be retained.
interval	The interval between each snapshot. The unit is minutes. The value range is [10 minutes, 525600 minutes (1 year)]. If the value is set to 0, it means to disable both automatic and manual snapshots, and use a larger system-defined value (110 years) as the retention time. If the value is set to NULL, the current interval setting will be retained.

obclient> CALL DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS('2265','16');
Query OK, 0 rows affected