Re: Number of database files
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Mon, 10 Mar 2008 22:43:05 +0100
Message-ID: <63lobbF27t7voU2@mid.individual.net>
>> 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."
Date: Mon, 10 Mar 2008 22:43:05 +0100
Message-ID: <63lobbF27t7voU2@mid.individual.net>
On 10.03.2008 18:06, A.ISS wrote:
> 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."
> 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.
Where's the difference? You set up 200 databases so you can set the parameter to max or the desired max easily. You can even write a script that will do it for you once. I still do not see the case here.
Cheers
robert Received on Mon Mar 10 2008 - 16:43:05 CDT