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.03.10.17.06.11.541769@gee-mail.kom>
>
> 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
Date: Mon, 10 Mar 2008 18:06:12 +0100
Message-Id: <pan.2008.03.10.17.06.11.541769@gee-mail.kom>
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
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.
regards,
Ivan Received on Mon Mar 10 2008 - 12:06:12 CDT