The MODIFY_SNAPSHOT_SETTINGS procedure is used to modify the WORKLOAD_REPOSITORY configuration 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 |
Note |
|---|---|
| retention | The retention period for a snapshot. Snapshots older than this period will be automatically deleted. The unit is minutes. Value range: [1,440 minutes (1 day), 52,560,000 minutes (100 years)].
|
| interval | The interval between snapshots, in minutes. Value range: [10 minutes, 525600 minutes (1 year)].
|
Examples
obclient> CALL DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS('2265','16');
Query OK, 0 rows affected