RE:Determinants of control file

From: <BINAY.KUMAR_at_ponl.com>
Date: Thu, 29 Nov 2001 05:01:26 -0800
Message-ID: <F001.003D0499.20011129043527@fatcity.com>

you can user "Alter database backup controlfile to trace" and then can have a look at all the desired parameters which was set while creating the database

Binay

---

Hi all,

The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc.,

But after creation of control files, where should i get details about these parameter values?...

i checked in v$controlfile and v$database... i didn't get enough info on it.

And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files.
Where will i get the sequence# of other control files then...

Nirmal,

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

---

The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you.

We reserve the right to monitor all e-mail communications through our network.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: BINAY.KUMAR_at_ponl.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Thu Nov 29 2001 - 07:01:26 CST