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 a snapshot, in minutes. Snapshots that have been retained for the specified period of time are automatically dropped. Valid values: [1440 minutes (1 day), 52560000 minutes (100 years)].
|
| interval | The interval at which snapshots are generated, in minutes. Valid values: [10 minutes, 525600 minutes (1 year)].
|
Examples
obclient[SYS]>CALL DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS('2265','16');
Query OK, 0 rows affected