Online Redo Log Members

Post date: May 20, 2014 3:37:43 PM

SELECT group#        ,

  thread#             ,

  sequence#           ,

  (bytes/1024)/1024 MB,

  members             ,

  status              ,

  first_change#       ,

  TO_CHAR(first_time,'DD-MON-YY HH24:MI SS') FIRST_TIME

from v$log