RE: Where once can find MAXLOGFILES value other than on "traced" control file?

Hi,

You can use

SQLPLUS> select TYPE,RECORDS_TOTAL from v$controlfile_record_section;

The type "REDO LOG" is your answer.

HTH,

Quamrul Polash

[@more@]

引自

另外如何檢視maxlogmembers?

SQL> Select '--&gt MAXLOGMEMBERS ' || dimlm from x$kccdi;

'--&gtMAXLOGMEMBERS'||DIMLM
----------------------------------------------------------
--&gt MAXLOGMEMBERS 3

SQL>


Got from