dba_hist_snapshot

AWR Snapshots for a day / Instance wise

set linesize 200
col snaptime for a25
select SNAP_ID,INSTANCE_NUMBER,to_char(BEGIN_INTERVAL_TIME,'DD-MON-YY HH24:MI:ss') snaptime
from dba_hist_snapshot
where to_char(BEGIN_INTERVAL_TIME,'DDMON')='&DDMON' and INSTANCE_NUMBER =&inst_Num
order by BEGIN_INTERVAL_TIME;