Oracle Redo Log Files Info

COL GROUP# FORMAT 999999 HEAD 'Group' COL THREAD# FORMAT 999999 HEAD 'Thread' COL SEQUENCE# FORMAT 99999999 HEAD 'Sequence' COL size FORMAT A6 HEAD 'Size|Mb' COL STATUS FORMAT A10 COL MEMBER FORMAT A60 COL switch_dt FORMAT A20 COL ARCHIVED FORMAT A7 BREAK ON THREAD# NODUP ON GROUP# NODUP SKIP 1 ON sizeMb NODUP ON switch_dt NODUP COMPUTE NUMBER LABEL 'MEMBER:' OF SEQUENCE# ON GROUP# SELECT L.GROUP#, L.THREAD#, L.SEQUENCE#, LPAD(TRUNC(BYTES/1024/1024),5) sizeMb, L.STATUS, MEMBER, TO_CHAR(FIRST_TIME, 'YYYY-MM-DD HH24:MI:SS') switch_dt, DECODE(ARCHIVED,'YES','Done..','Non') ARCHIVED FROM V$LOG L, V$LOGFILE F WHERE L.GROUP# = F.GROUP# ORDER BY 1,3,6;