Redo Log Files and Sizing
set heading off;
select '******************************************************' from dual;
select '**** Redo Log Files and Sizing ****' from dual;
select '******************************************************' from dual;
timing start 'Redo Sizing';
set heading on;
col "File Name" for a60;
col "Size in MB" format 999,999,999,999,990
select a.group#, thread#, substr(a.member,1,80) as "File Name",b.bytes/1024/1024 as "Size in MB" from v$logfile a,v$log b where a.group#=b.group#;
timing stop 'Redo Sizing';
Hope this helps. Regards Rupam
