Search notes:

v$archive_processes

V$archive_processes contains a record for each possible enableable archiver process (ARCn), independent if running or not.
select
   count(*),
   status,
   state
from
   v$archive_processes
group by
   status,
   state;

See also

The init parameter log_archive_max_processes

Index