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;
col snap_interval format a20col retention format a20select * from dba_hist_wr_control;exec dbms_workload_repository.modify_snapshot_settings(interval=>30,retention=>31*24*60);select * from dba_hist_wr_control;