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

The MODIFY_SNAPSHOT_SETTINGS procedure modifies the WORKLOAD_REPOSITORY settings and is available only in the sys tenant.

Syntax

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

Parameter	Description
retention	The retention period of snapshots, in minutes. Snapshots that exceed this period are automatically deleted. The value range is [1440 minutes (1 day), 52560000 minutes (100 years)]. The value `0` specifies to permanently retain the snapshots. In this case, the retention period is 57,816,000 minutes (110 years). The value `NULL` specifies to use the original retention period.
interval	The time interval between snapshots, in minutes. The value range is [10 minutes, 525600 minutes (1 year)]. The value `0` specifies to disable automatic and manual snapshots and to use a large value defined by the system (110 years) as the retention period. The value `NULL` specifies to use the current time interval.

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