V$ARCHIVE_PROCESSES definition in Oracle Database 11.2
V$ARCHIVE_PROCESSES

select
  PROCESS,                                 -- PROCESS NUMBER
  STATUS,                                  -- STATUS VARCHAR2(10)
  LOG_SEQUENCE,                            -- LOG_SEQUENCE NUMBER
  STATE                                    -- STATE VARCHAR2(4)
from
  GV$ARCHIVE_PROCESSES
where
  inst_id = USERENV('Instance')

home |  up