v$archived_log

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;