Check Redo Log Size

SELECT

l.GROUP#,

l.THREAD#,

l.SEQUENCE#,

l.ARCHIVED,

l.STATUS,

lf.MEMBER AS REDOLOG_FILE_NAME,

(l.BYTES/1024/1024) AS SIZE_MB

FROM v$log l

JOIN v$logfile lf ON l.Group#=lf.Group#

ORDER BY l.GROUP# ASC;

Output: