RE: Any way to 'truncate' the control file?

From: Uma Sankara_Sivadanam <UmaSankara_Sivadanam_at_satyam.com>
Date: Wed, 2 Aug 2000 10:35:00 +0530
Message-Id: <10576.113554@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFFC3F.3425D9F0
Content-Type: text/plain

Hello Friend,

There are 5 parameters that decide the size of a control file.

Maxdatafiles,maxlogfiles,maxlogmembers,maxloghistory and maxinstances.

For a given database based on these parameters in the init file(at the time of DB creation) the control file is generated.For your DB may be those parameters are very high.Youn can resize your control file by backing up changing these parameters in that file.Refer some book for this as i don't remember all the steps involved.

By the way what is your oracle version?From oracle 8 , i believe the control file will keep on growing (automatically) when ever a datafile or logfile is added.

Uma Shankar.

> ----------
> From: 	Zhong Hong[SMTP:zhong_at_cantametrix.com]
> Reply To: 	ORACLE-L_at_fatcity.com
> Sent: 	Tuesday, August 01, 2000 5:56 PM
> To: 	Multiple recipients of list ORACLE-L
> Subject: 	Any way to 'truncate' the control file?
> 
> My contril file is about 39MB for a 150GB Database. Anybody knows what
> could
> cause that and how to reduce the size?
> 
> TIA,
> Zhong
> It's another beautiful day!
>

------_=_NextPart_001_01BFFC3F.3425D9F0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Any way to 'truncate' the control file?</TITLE>
</HEAD>
<BODY>

Hello Friend,


There are 5  =
parameters  that decide the size of a control file.


Maxdatafiles,maxlogfiles,maxlogmembers,maxloghistory and = maxinstances.


For a given database =
based on these parameters in the init file(at the time of DB creation) = the control file is generated.For your DB may be those parameters are = very high.Youn can resize your control file by backing up  = changing these parameters in that file.Refer some book for this as i = don't remember all the steps involved.

By the way what is =
your oracle version?From oracle 8 , i believe the control file will = keep on growing (automatically) when ever a datafile or logfile is = added.

Uma Shankar.

<UL>
----------
 From:   =
Zhong =
Hong[SMTP:zhong_at_cantametrix.com]
 Reply To: =
      ORACLE-L_at_fatcity.com
 Sent:   =
Tuesday, August 01, 2000 5:56 =
PM
 To: =
    Multiple = recipients of list ORACLE-L
 Subject: =
       Any way to 'truncate' the control file?


My contril file is about 39MB for a =
150GB Database. Anybody knows what could
 cause that and how to reduce the =
size?


TIA,
 Zhong
 It's another beautiful day!
Received on Wed Aug 02 2000 - 00:05:00 CDT