Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Correlation? init.ora: db_files and controlfile: maxdatafiles

Re: Correlation? init.ora: db_files and controlfile: maxdatafiles

From: Sean Fitzgerald <sfitzgerald_at_centurytel.net>
Date: Tue, 2 Oct 2001 21:13:54 -0700
Message-ID: <FHtu7.8568$tE2.4236012@feed.centurytel.net>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:trk993kejc0jd4_at_news.demon.nl...
>
> "Johannes Bavendiek" <JohannesBavendiek_at_gmx.de> wrote in message
> news:df6af3e.0110020614.2e3ed483_at_posting.google.com...
> > Question for Oracle 8.0.4 and Oracle 8.1.7.
> >
> > We have a large DB with 238 files, and it is still growing.
> > The init.ora parameter DB_FILES is set to 254.
> > It is easy to increase it (set to 1024 and restart DB).
> >
> > But in the controlfiles there is a parameter MAXDATAFILES, also set to
> 254.
> > Do I have to increase this also?
> > And how?
> >
> > What is the correlation between db_files and MAXDATAFILES?
> >
> > cu
> > Johannes
>
>
> Max_data_files is the *static* limit which was used in creating the
> controlfiles.
> This means you won't be able to increase db_files beyond max_data_files.
> Normally you would need to recreate the database.
> However I think that using more than 200 datafiles is *very undesirable*
and
> if I would have to consult at your site I would address this issue
> *immediately*
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
>

In 8i maxdatafiles is not static. It will automatically grow up to a maximum of 65536 on unix systems. No controlfile recreation necessary. You can keep increasing db_files in the init.ora. However, if you are constantly adding files to the database you should make sure you are sizing them large enough (ie, don't create many, small datafiles where one or two big datafiles will do). Received on Tue Oct 02 2001 - 23:13:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US