Re: How to Get MAXLOGFILES?

tahmossx_at_itd.ssb.com (Stephen A Tahmosh) wrote:
>Here's one way:
>in sqldba (svrmgrl),
> connect internal
> alter database backup controlfile to trace;
>exit
>
>in user_dump_dest ("show parameter dump" while in sqldba to find location), the trace file created by the
>above alter database command will list the maxlogfiles value.
>
>Good luck,
>Steve
>
>ghubert_at_acpub.duke.edu (Gene Hubert) wrote:
>>How do I determine the value of MAXLOGFILES for an existing
>>Oracle 7.2 db?
>>
>>Thanks,
>>
>>gene hubert
>>
>
>
Hi there,

Logon to SQLDBA / SVRMGRL as internal. and type SHOW PARAMETERS LOG

It will display all LOG parameters of which MAXLOGFILES is one of them.

Regards

N.Prabhakar Received on Fri Dec 06 1996 - 00:00:00 CET