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

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License