| 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);
Parameters
| 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)].
|
| interval | The interval between each snapshot. The unit is minutes. The value range is [10 minutes, 525600 minutes (1 year)].
|
Examples
obclient> CALL DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS('2265','16');
Query OK, 0 rows affected