Re: maxlogfiles and maxlogmembers

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 8 Nov 1999 19:19:41 GMT
Message-ID: <8077od$ljh$1@news.seed.net.tw>

Aamir Siddiqi <aamir_mas_at_hotmail.com> wrote in message news:3825c316_at_news.cyber.net.pk...
> Hi,
>
> You can execute the following select statement at Server Manager, SQL DBA or
> SQL Plus to find out the number of Log Files; and their statistics
>
> SELECT * FROM v$logfile;

No. You can NOT find any things about the config settings from v$logfile.

> Christ Follower <christ_follower_at_my-deja.com> wrote in message
> news:800bmc$rb0$1_at_nnrp1.deja.com...
> > How do I find out maxlogfiles and maxlogmembers settings in an existing
> > database? Thanks.

One quick way is: issue the command

alter database backup controlfile to trace;

Then, find them from a trace file. Received on Mon Nov 08 1999 - 13:19:41 CST