select thread#, max(sequence#) max_seq,to_char(max(first_time), 'yyyy-mm-dd hh24:mi:ss') sync_time from v$log_history group by thread# order by  thread#;