Re: Large tablespace in 8.17
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 06 Feb 2008 19:25:18 +0100
Message-ID: <a4f28$47a9fb8e$524b5c40$24650@cache3.tilbu1.nb.home.nl>
>> "gazzag" <gar..._at_jamms.org> wrote in message
>>
>> news:f1dccfa7-7f86-4528-a5c9-a05fe8cd6490_at_l16g2000hsh.googlegroups.com...
>> On 6 Feb, 11:03, "xxxx" <timo.ta..._at_luukku.com> wrote:
>>
>>> Hi,
>>> what might be the best way to create a large tablespace in 8.17 db ; -
>>> should there be several datafiles
>>> - first there's a upload made which gives that size approx ~8 -10 GB
>>> - after that every insert adds another ~ 5 MB
>>> Every hint for some basic values are beeing appreciated !
>>> Br,
>>> Ttimo
>> Operating system?
>>
>> Hp OpenVMS Alpha
Date: Wed, 06 Feb 2008 19:25:18 +0100
Message-ID: <a4f28$47a9fb8e$524b5c40$24650@cache3.tilbu1.nb.home.nl>
gazzag wrote:
> On 6 Feb, 11:27, "timo" <timo.ta..._at_luukku.com> wrote:
>> "gazzag" <gar..._at_jamms.org> wrote in message
>>
>> news:f1dccfa7-7f86-4528-a5c9-a05fe8cd6490_at_l16g2000hsh.googlegroups.com...
>> On 6 Feb, 11:03, "xxxx" <timo.ta..._at_luukku.com> wrote:
>>
>>> Hi,
>>> what might be the best way to create a large tablespace in 8.17 db ; -
>>> should there be several datafiles
>>> - first there's a upload made which gives that size approx ~8 -10 GB
>>> - after that every insert adds another ~ 5 MB
>>> Every hint for some basic values are beeing appreciated !
>>> Br,
>>> Ttimo
>> Operating system?
>>
>> Hp OpenVMS Alpha
> > I have no experience in this O/S. Are there any limits on file size, > as this will obviously form part of the answer?
If there are limits, make 6 files of 2GB fixed sizing. This will allow for the initial load, and some time for updates.
If "large files" are supported, it's a balance between backups/restore
time and sizing. You have to be the judge of that.
2GB each for starters, autoextending, with an upper limit
of 4GB could do. So could a single file of 10GB (10GB is not
that big...)
Make sure you monitor your filesystems, if you do. Without filesystem
monitoring, go for fixed datafile sizes, and create them max size.
-- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me upReceived on Wed Feb 06 2008 - 12:25:18 CST