In this example the retention period is specified as 1 month (43200 minutes) and the interval between each snapshot is 30 minutes.
BEGIN
DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS (INTERVAL => 30,RETENTION => 43200);
END
SELECT * FROM DBA_HIST_WR_CONTROL
After executing DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS procedure you can get the AWR Report for each 30 min the hole year.DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS (INTERVAL => 30,RETENTION => 43200);
END
SELECT * FROM DBA_HIST_WR_CONTROL