除了TRACE文件,在哪查看数据库的 maxlogfiles ?

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@]

引自

http://www.freelists.org/post/oracle-l/Where-once-can-find-MAXLOGFILES-value-other-than-on-traced-control-file,1

另外如何查看maxlogmembers?

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

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

SQL>


Got from http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:83612348058

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/271063/viewspace-1030851/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/271063/viewspace-1030851/