Re: Large tablespace in 8.17
Date: Wed, 06 Feb 2008 19:25:18 +0100
> On 6 Feb, 11:27, "timo" <timo.ta..._at_luukku.com> wrote:
>> "gazzag" <gar..._at_jamms.org> wrote in message
>> On 6 Feb, 11:03, "xxxx" <timo.ta..._at_luukku.com> wrote:
>>> 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 !
>> 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
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