col snap_interval format a20
col retention format a20

select * from dba_hist_wr_control;

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

select * from dba_hist_wr_control;