FIRST_TIME DATE Timestamp of the first change
NEXT_TIME DATE Timestamp of the next change
select min(first_time) mintime,max(next_time) maxtime from v$archived_log;
col name format a90
select name from v$archived_log where sequence#=402;
select thread#, blocks*block_size/1024/1024 as MB, first_time, next_time from v$archived_log where sequence#=402;
select thread#, first_time, next_time, completion_time from v$archived_log where sequence#=403;