Show REDO Information
-- -- Show REDO Log Information. -- SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 60 SET LINESIZE 300 SET VERIFY OFF COL group# HEA " Group " FOR 99 COL sequence# HEA " Sequence " FOR 9,999,999,999 COL bytes HEA " Datafile Size (bytes) " FOR 999,999,999,999,999 COL members HEA " Member " FOR 999 COL member HEA " Datafile Name " FOR a44 COL archived HEA " Arc? " FOR a4 COL status HEA " Status " FOR a16 COL first_changed# HEA " First Changed No. " FOR 999,999,999,999 COL first_time HEA " First Time " FOR a20 SELECT l.group#, l.members, l.sequence#, lf.member, l.bytes, l.status, l.archived, l.first_change#, To_Char(l.first_time,'DD-Mon-YYYY HH24:MI:SS') as first_time FROM v$log l,v$logfile lf WHERE l.group# = lf.group# /