redo_num

col status for a20 col MEMBER_NAME for a60 select f.group# "GROUP", l.thread# "THREAD", l.sequence# "SEQ_NBR", l.archived "ARC", substr(l.status,1,10) "STATUS", l.bytes/1024/1024 "size", substr(f.member,1,60) "MEMBER_NAME", first_time from v$logfile f, v$log l where f.group# = l.group# order by f.group#, f.member;