MODIFY_SNAPSHOT_SETTINGS

The MODIFY_SNAPSHOT_SETTINGS procedure is used to modify the configuration of the WORKLOAD_REPOSITORY.

Syntax

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

Parameters

Parameter	Description
retention	The retention period for a snapshot, in minutes. Snapshots older than this period will be automatically deleted. Valid values: [1440 minutes (1 day), 52560000 minutes (100 years)]. If the value is set to 0, the snapshot will be retained permanently, with a retention period of 57816000 minutes (110 years). If the value is NULL, the original retention period will be retained.
interval	The interval between snapshots, in minutes. Valid values: [10 minutes, 525600 minutes (1 year)]. If the value is set to 0, automatic and manual snapshots will be disabled, and a larger system-defined value (110 years) will be used as the retention period. If the value is NULL, the current interval setting will be retained.

Examples

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