RE: How to change the value of MAXDATAFILES of a running instance

Hi,
I think people are confusing two parameters, MAXDATAFILES parameter during database creation and the INIT.ORA parameter DB_FILES. MAXDATAFILES is the upper limit you set in your database creation script. You must recreate the controlfile in order to increase this limit. DB_FILES can be anything up to and including MAXDATAFILES and it will take effect after bouncing the instance. The larger MAXDATAFILES is the larger your control file becomes and the more memory it takes. Please correct me if I'm mistaken.

-
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: chris.guidry_at_atcoelectric.com

> -----Original Message-----
> From: Stephen J Palmer [SMTP:spalmer_at_brk.photronics.com]
> Sent: Tuesday, May 30, 2000 2:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: How to change the value of MAXDATAFILES of a running
> instance ?
>
> This may not be my place.... but can't you just make the change in the
> init.ora
> file
> and bounce the instance. I don't believe you have to recreate the
> controlfile...
> but
> I believe you will have to bounce the instance to have the new setting
> take
> effect.?
>
> Please let me know if this is not correct.
>
> Thanks
> Steve
>
> Steve Boyd wrote:
>
> > I'm surprised that nobody else has answered this one yet, so I'll go
> ahead
> > and post.
> >
> > You need to recreate the controlfile. Do the good old ALTER DATABASE
> BACKUP
> > CONTROLFILE TO TRACE;
> >
> > Up the parameter in the script this generates, and recreate the
> controlfile.
> > Of course, you will need to take down your database to do this.
> >
> > >From: ALEMU Abiy <abiy.alemu_at_criltechnology.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: How to change the value of MAXDATAFILES of a running instance
> ?
> > >Date: Tue, 30 May 2000 07:56:04 -0800
> > >
> > >Is there somebody who knows how to change the MAXDATAFILES parameter
> value
> > >of a running database ? If so, I'm really very grateful to anyone who
> can
> > >explain me.
> > >
> > >Thank you friends !!!
> > >--
> > >Author: ALEMU Abiy
> > > INET: abiy.alemu_at_criltechnology.com
> > >
> > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > >San Diego, California -- Public Internet access / Mailing Lists
> > >--------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from). You may
> > >also send the HELP command for other information (like subscribing).
> >
> > ________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> > --
> > Author: Steve Boyd
> > INET: pimaco_oracle_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> Stephen Palmer
> Junior Database Administrator
> Photronics Inc.
> 15 Secor Road
> Brookfield, Conn.
> 203.740.5331
> Pager 203-830-0306 or 1-800-706-7109
> mailto:spalmer_at_brk.photronics.com
> Home Number 203.270.8159
> Alpha Pager mailto:spalmer.pager_at_brk.photronics.com
>
>
> --
> Author: Stephen J Palmer
> INET: spalmer_at_brk.photronics.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue May 30 2000 - 15:27:38 CDT