Oracle Tips: Retaining AWR report

DBAs would want to preserve the AWR snapshots beyond the default 7 day period for performance analysis. This will help to query dba_hist tables.

 

execute dbms_workload_repository.modify_snapshot_settings(interval => <minutes for snapshot>,retention => <no. of days in minutes>);