Re: How can I get archive log destination path?
From: Phil Fielder <fimad_at_archie.lanl.gov>
Date: 1995/06/22
Message-ID: <3scrm8$gkb_at_newshost.lanl.gov>#1/1
/u24/ORACLE/ERDB/arch/arch_
Date: 1995/06/22
Message-ID: <3scrm8$gkb_at_newshost.lanl.gov>#1/1
vlohia_at_oes.amdahl.com (Ved Lohia) wrote:
>SQL*DBA monitor provides this info but I need it in my script.
>
Ved,
If you mean an SQL script, here's one technique :
SQL> select value from v$parameter where
2 name = 'log_archive_dest'
3 ;
VALUE
/u24/ORACLE/ERDB/arch/arch_
hth,
phil
-- Philip Fielder YellNet 505.665.3227 Facility for Infor.,Management, EES-5/MS D452 FaxNet 505.667.1628 Analysis and Display FIMAD/Los Alamos Nat. Lab Los Alamos, NM 87545 URL : http://ees5-www.lanl.gov/EES5/fimad/fimad_main.htmlReceived on Thu Jun 22 1995 - 00:00:00 CEST