Get redo log member info

col member for a56
set pagesize 299
set lines 299

select l.group#, l.thread#,
f.member,
l.archived,
l.status,
(bytes/1024/1024) “Size (MB)”
from
v$log l, v$logfile f
where f.group# = l.group#
order by 1,2
/

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

One thought on “Get redo log member info

  1. A fascinating discussion is definitely worth comment. I do believe that you ought to write more about this subject matter, it may not be a taboo matter but usually people don’t speak about these subjects. To the next! Cheers!!