Oracle: Modify AWR snapshot frequency and retention period.

Tags:

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;