Oracle: Modify AWR snapshot frequency and retention period.
execute dbms_workload_repository.modify_snapshot_settings ( interval => 10,retention => 14400000);
Note: retention and interval are in minutes
To manually create a snapshot:
execute dbms_workload_repository.CREATE_SNAPSHOT;
- inforadar's blog
- Login or register to post comments
