-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -- Author : Sameer S Choudhari -- Description : Displays the online redo log information -- Call Syntax : @online_redo_log_info.sql -- Last Modified: 17/03/2015 -- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ SET LINES 220 PAGES 49999 COLUMN MEMBER FORMAT a60 SELECT lf.group#, lf.MEMBER, lf.TYPE, L.sequence#, L.BYTES/1024/1024 size_mb, L.BLOCKSIZE, L.members, L.ARCHIVED, L.status FROM v$log L, v$logfile lf WHERE L.group#=lf.group# ORDER BY lf.group#, lf.MEMBER;