awr_hist

select snap_id, to_char(begin_interval_time, 'DD-MON-YY HH24:MI'),
to_char(end_interval_time, 'DD-MON-YY HH24:MI')from
dba_hist_snapshot where
begin_interval_time>sysdate-1 order by
begin_interval_time desc;