RE: Determinants of control file

[K Gopalakrishnan]

Title: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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:[EMAIL PROTECTED]] 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,