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


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.html
Received on Thu Jun 22 1995 - 00:00:00 CEST

Original text of this message