Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Location of redo logs

Re: Location of redo logs

From: raman batra <rrbatra_at_feist.com>
Date: Fri, 23 Oct 1998 22:28:10 -0500
Message-ID: <3631494A.45E6@feist.com>


In SQL Worksheet or Server Manager you could just type : SHOW PARAMETER LOG_ARCHIVE_DEST and it well tell you.

Jurij Modic wrote:
>
> On Fri, 23 Oct 1998 22:17:31 GMT, jmodic_at_src.si (Jurij Modic) wrote:
>
> >More straightforward way would be:
> >
> >SELECT name, value FROM V$PARAMETER WHERE NAME =
> >'log_archive_destinat';
>
> Ooops, that should read ...WHERE NAME ='log_archive_dest';
>
> Jurij Modic <jmodic_at_src.si>
> Certified Oracle7 DBA (OCP)
> ================================================
> The above opinions are mine and do not represent
> any official standpoints of my employer
Received on Fri Oct 23 1998 - 22:28:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US