select
  GROUP#,                                  -- GROUP# NUMBER
  THREAD#,                                 -- THREAD# NUMBER
  SEQUENCE#,                               -- SEQUENCE# NUMBER
  BYTES,                                   -- BYTES NUMBER
  BLOCKSIZE,                               -- BLOCKSIZE NUMBER
  MEMBERS,                                 -- MEMBERS NUMBER
  ARCHIVED,                                -- ARCHIVED VARCHAR2(3)
  STATUS,                                  -- STATUS VARCHAR2(16)
  FIRST_CHANGE#,                           -- FIRST_CHANGE# NUMBER
  FIRST_TIME,                              -- FIRST_TIME DATE
  NEXT_CHANGE#,                            -- NEXT_CHANGE# NUMBER
  NEXT_TIME                                -- NEXT_TIME DATE
from
  GV$LOG
where
  inst_id = USERENV('Instance')