Re: maxlogfiles and maxlogmembers

From: Karen Olsson <olsson_at_tst.tracor.com>
Date: Mon, 08 Nov 1999 14:22:53 -0500
Message-ID: <3827230D.84EC94B0@tst.tracor.com>

Checking v$logfile just returns info on your current logs. To find out the maxlogfiles and maxlogmembers setting, I would look for your crdb{$ORACLE_SID}.sql files created when your database was created. On my old SCO UNIX RDBMS V7.2 database, it's under $ORACLE_HOME/dbs. Not sure where other RDBMS versions place them?
HTH,
Karen

Aamir Siddiqi wrote:

> 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;
>
> Regards,
>
> 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.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Mon Nov 08 1999 - 13:22:53 CST