SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME, COMPLETION_TIME, APPLIED, DELETED FROM V$ARCHIVED_LOG ORDER BY FIRST_TIME desc;