Re: Number of database files

From: A.ISS <ais_at_gee-mail.kom>
Date: Mon, 10 Mar 2008 18:06:12 +0100
Message-Id: <pan.2008.>

On Mon, 10 Mar 2008 01:36:04 -0700, Robert Klemme wrote:

> On Mar 9, 12:45 pm, "A.ISS" <a..._at_gee-mail.kom> wrote:

>> [quoted text muted]

> I don't understand this requirement. Since you should be creating DB
> files ahead of time you could as well monitor DB size and check the init
> param when creating a new datafile. At that point in time there should be
> enough time left to adjust db_files and schedule a maintenance window.
> If you have a constantly growing database you can as well set it to max.
> From 10.2 docs:
> "The maximum valid value is the maximum number of files, subject to
> operating system constraint, that will ever be specified for the database,
> including files to be added by ADD DATAFILE statements."
> Cheers
> robert


Maybe you are right when you have 1 database. But if you have over 200 db's then you want to anticipate as much as possible.


Ivan Received on Mon Mar 10 2008 - 12:06:12 CDT

Original text of this message