dba_hist_snapshot records information (such as start and end time) about each snapshot. select snp.begin_interval_time, snp.begin_interval_time_tz, snp.con_id, snp.dbid, snp.end_interval_time, snp.end_interval_time_tz, snp.error_count, snp.flush_elapsed, snp.instance_number, snp.snap_flag, snp.snap_id, snp.snap_level, snp.snap_timezone, snp.startup_time from sys.dba_hist_snapshot snp order by snp.end_interval_time desc ;