AWR command reference

1.To check the setup

select * from dba_hist_wr_control;

2.To change retention and/or period

SQL>  exec dbms_workload_repository.modify_snapshot_settings(retention=>90*24*60, interval=>30);

Above command makes retention to 90 days
and inter to 30 mins