Re: Location of redo logs

From: <satar_at_my-dejanews.com>
Date: Fri, 23 Oct 1998 22:28:53 GMT
Message-ID: <70qvv4$9tc$1@nnrp1.dejanews.com>

If you are talking about The redo logs themselves, then you can do a select: select * from v$logfile

To get information of the log files:
select * from v$log

In article <70qdm9$1u8k1_at_tmpsp002.tmpprv.allied.com>, "Zachary Agatstein" <Zachary.Agatstein_at_atsc.allied.com> wrote:
> A newbie question:
> If I don't have a LOG_ARCHIVE_DEST parameter specified in my initxxx.ora
> file, how do I find out where these redo logs reside?
>
> Thanks
>
> Zach
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 23 1998 - 17:28:53 CDT