awr_ret_interval

col snap_interval for a20
col retention for a20
select snap_interval, retention from dba_hist_wr_control;

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;

select max(snap_id) max_snapd, min(snap_id) min_snapd, 'Today AWR Snapshots : '||min(snap_id) || '-'|| max(snap_id) "Today"
from dba_hist_snapshot
where TO_CHAR(TRUNC(end_interval_time),'DD-MON-YY' ) = to_char(sysdate,'DD-MON-YY') and instance_number = userenv('instance') and dbid =
(select dbid
from v$database);

select MOST_RECENT_SNAP_ID max_snapd, MOST_RECENT_SNAP_ID - (60 / ( extract ( hour
from snap_interval) * 60 + extract( minute
from SNAP_INTERVAL ) ) * to_char(sysdate,'HH24') ) min_snapd
from sys.wrm$_wr_control
where dbid = (
select dbid
from v$database)