select group#, sequence#, bytes / 1024 / 1024, members, status from v$log;
select member from v$logfile;
select * from v$logfile order by 1;
select group#, thread#, bytes / 1024 / 1024, archived, status, members
from v$log;
select group#, sequence#, bytes / 1024 / 1024, members, status from v$log;
select member from v$logfile;
select * from v$logfile order by 1;
select group#, thread#, bytes / 1024 / 1024, archived, status, members
from v$log;