📋Steps in this guide1/1

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 /

oracle configurationintermediate

by OracleDba

10 views

Get redo log member info

Code/Command (click line numbers to comment):

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
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!