AWR Snapshots

To verify the frequency of these snapshots, issue the following command:

SQL>  select snap_interval, retention
                 from dba_hist_wr_control;

SNAP_INTERVAL             RETENTION
------------------------- -------------------------
+00000 01:00:00.0         +00007 00:00:00.0

To change the settings for snapshot intervals of 30 minutes and a retention period of 30 days, issue the following command. The retention parameters are specified in minutes:

begin
   dbms_workload_repository.modify_snapshot_settings (
      interval => 30,
      retention => 30*24*60
   );
end;