V$ARCHIVE definition in Oracle Database 11.2
V$ARCHIVE

select
  GROUP#,                                  -- GROUP# NUMBER
  THREAD#,                                 -- THREAD# NUMBER
  SEQUENCE#,                               -- SEQUENCE# NUMBER
  ISCURRENT,                               -- ISCURRENT VARCHAR2(3)
  "CURRENT",                               -- CURRENT VARCHAR2(3)
  FIRST_CHANGE#                            -- FIRST_CHANGE# NUMBER
from
  GV$ARCHIVE
where
  inst_id = USERENV('Instance')

home |  up