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

From: Quamrul Polash <quapol_at_hotmail.com>
Date: Tue, 12 Dec 2006 03:43:08 +0000
Message-ID: <BAY124-W36142DBE52098F49B4AE4BD9D70@phx.gbl>

Hi,  

You can use  

SQLPLUS> select TYPE,RECORDS_TOTAL from v$controlfile_record_section;  

The type "REDO LOG" is your answer.  

HTH,   Quamrul Polash

Date: Mon, 11 Dec 2006 14:06:15 -0500From: drp4kri_at_gmail.comTo: oracle-l_at_freelists.orgSubject: Where once can find MAXLOGFILES value other than on "traced" control file?Hi,Just came across this scenario where I need to increase MAXLOGFILES and re-create the control files. Of course, by dumping binary control file to a traced version would show what is the current value for thisparameter, but is there any view that could provide this information? -Thanks,DP

---

Search from any Web page with powerful protection. Get the FREE Windows Live Toolbar Today! http://get.live.com/toolbar/overview

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Dec 11 2006 - 21:43:08 CST