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);
Parameters
| 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)].
|
| interval | The time interval between snapshots, in 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