Re: Determining the value of MAXLOGFILES and MAXLOGMEMBERS

"FC" <flavio_at_tin.it> wrote in message news:<Xqaqa.6218$K35.159609_at_news2.tin.it>...
> Hello folks,
> I can't find any documents explaining how to retrieve the value of
> MAXLOGFILES and MAXLOGMEMBERS using dynamic views.
> Do you know how to do that?
> I need to do this in a sql script.
>
> Thanks,
> Flavio

These values are recorded in the controlfiles. You can use

ALTER DATABASE BACKUP CONTROLFILE TO TRACE to view the values.

You can also retrieve them from v$controlfile_record_section and x$kccdi See Metalink Note:104933.1

• Jusung Yang