RE: Determinants of control file

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Other than dumping/ tracing the control file, you can find the required details in the

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>dynamic view V$controlfile_record_section. This view has all the information you want

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<span

style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<!---size:10.0pt;mso-bidi-font-size:

12.0pt;font-family:Arial'><span
style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail Signature" <font
color=navy>Best Regards,<font
color=navy>

<span

style='font-size:12.0pt;color:navy'>K Gopalakrishnan<font color=navy>

<span

style='font-size:12.0pt;color:navy'> <font color=navy>

<!---size:10.0pt;mso-bidi-font-size:

12.0pt;font-family:Arial'><span
class=EmailStyle16><span style='font-size: 10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'> 

<font size=2 color=black

face=Tahoma>-----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

<span

style='font-size:12.0pt'> 

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>Hi Nirmal,<font color=black>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>   Use <font color=black>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>    alter database backup controlfile to trace;<span style='color:black;mso-color-alt:windowtext'>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>    <font color=black>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>    You can find these details in the trace file, that will be dumped to your udump destination.<span style='color:black;
mso-color-alt:windowtext'>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>HTH<font color=black>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>Srinivas.<font color=black>

<font size=3 color=black

face="Times New Roman"> <font
color=black>

<span

style='font-size:10.0pt;font-family:Arial;color:blue'>   <font color=black>

<p class=MsoNormal style='mso-margin-top-alt:0in;margin-right:0in;margin-bottom:
12.0pt;margin-left:.5in'><span
style='font-size:10.0pt;font-family:Tahoma;color:black'>-----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<span style='font-size:
10.0pt;font-family:Tahoma;color:black;mso-color-alt:windowtext'>

<span

style='font-size:10.0pt;font-family:Arial;color:black'>Hi all,<font
color=black> <span
style='color:black;mso-color-alt:windowtext'>

<span

style='font-size:10.0pt;font-family:Arial;color:black'>The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc.,<font color=black> <span
style='color:black;mso-color-alt:windowtext'>

<span

style='font-size:10.0pt;font-family:Arial;color:black'>But after creation of control files, where should i get details about these parameter values?...<font color=black> <span
style='color:black;mso-color-alt:windowtext'>

<span

style='font-size:10.0pt;font-family:Arial;color:black'>i checked in v$controlfile and v$database... i didn't get enough info on it.<font color=black> <span
style='color:black;mso-color-alt:windowtext'>

<span

style='font-size:10.0pt;font-family:Arial;color:black'>And i found controlfile_sequence# column i found in v$database view. I multiplexed the control files.
<span style='font-size:10.0pt;

font-family:Arial;color:black'>Where will i get the sequence# of other control files then... <font
color=black>

<span

style='font-size:10.0pt;font-family:Arial;color:black'>Nirmal,<font
color=black> <span
style='color:black;mso-color-alt:windowtext'>