Search notes:

v$archive_dest

Shows all archived redo logs destinations.
Compare with the init parameter log_archive_dest_n.
select
  dest_id,
  destination
from
  v$archive_dest
Github repository oracle-patterns, path: /Installed/dynamic-performance-views/archive/dest/show-destinations.sql

See also

Oracle Dynamic Performance Views

Index