AWR Retention and period

Oracle AWR Retention period   ..

SELECT extract(day from snap_interval) *24*60+extract(hour from snap_interval) *60+extract(minute from snap_interval) snapshot_Interval,

extract(day from retention) *24*60+extract(hour from retention) *60+extract(minute from retention) retention_Interval

FROM dba_hist_wr_control;

SNAPSHOT_INTERVAL RETENTION_INTERVAL

----------------- ------------------

               60              11520  <<<<In min 

set lines 200

col snap_interval        format a20

col retention            format a20

select * from dba_hist_wr_control;

      DBID SNAP_INTERVAL        RETENTION            TOPNSQL                                      CON_ID

---------- -------------------- -------------------- ---------------------------------------- ----------

2955063305 +00000 01:00:00.0    +00008 00:00:00.0    DEFAULT                                           0

                                     ^

                                     Days

To Change 15 minutes and retention to 30 days (30x24x60 = 43200)

SQL> exec dbms_workload_repository.modify_snapshot_settings(interval => 15, retention => 43200)