--

-- 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#

/