RE: Determinants of control file

[Tatireddy, Shrinivas (MED, Keane)]

Title: 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,