RE: Determinants of control file

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Sat, 01 Dec 2001 06:48:06 -0800
Message-ID: <F001.003D2A8F.20011201062517@fatcity.com>

No..... i already checked the view v$control_record_section,

This view does not provide any information regarding determinants of controlfile like MAXDATAFILES, MAXLOGFILES, etc....

Nirmal.

-----Original Message-----

From:   K Gopalakrishnan [SMTP:kaygopal_at_yahoo.com]
Sent:   Thursday, November 29, 2001 11:27 PM
To:     Multiple recipients of list ORACLE-L

Subject:        RE: Determinants of control file

Other than dumping/ tracing the control file, you can find the required details in the dynamic view V$controlfile_record_section. This view has all the information you want
 
 

Best Regards,
K Gopalakrishnan
 
 

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Tatireddy, Shrinivas (MED, Keane) Sent: Thursday, November 29, 2001 3:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Determinants of control file
 

Hi Nirmal,
 
   Use
 
    alter database backup controlfile to trace;
   
    You can find these details in the trace file, that will be dumped to your udump destination.
 

HTH
Srinivas.
 
  

-----Original Message-----
From: Nirmal Kumar Muthu Kumaran [mailto:NIRMALK_at_qtel.com.qa] Sent: Thursday, November 29, 2001 7:52 AM To: Multiple recipients of list ORACLE-L Subject: Determinants of control file
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, Received on Sat Dec 01 2001 - 08:48:06 CST