Home  >  Oracle Database Administration (DBA)  >  Scripts  >  Find Oracle redo log file size

Find the actual SIZE & STATUS of each group/ member:

SELECT a.group#,
               b.STATUS,
               a.MEMBER, 
               b.BYTES/1024/1024 "Size (Mb)"
 FROM v$logfile a,
             v$log b
WHERE a.group# = b.group#;