online_redo_log_info.sql

-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 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;