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: