arch.sql

-- ************************************************************************************************************
-- * Filename           : arch.sql
-- * Author             : Saravanakumar K
-- * Description        : This script with show archivelog dest values from parmeter
-- * Usage              : @arch.sql
-- * Version            : v1
-- *************************************************************************************************************
set echo off
SET LINES 250 PAGES 49999 FEEDBACK OFF ECHO OFF
COL value FOR a180
COL name FOR a30

SELECT
    inst_id,
    name,
    value
FROM
    gv$system_parameter
WHERE
    name IN (
        'log_archive_dest_1',
        'log_archive_dest_2',
        'log_archive_dest_3',
        'log_archive_dest_state_1',
        'log_archive_dest_state_2',
        'log_archive_dest_state_3'
    )
ORDER BY
    1,2
/
clear col