Re: Large tablespace in 8.17

From: Frank van Bortel <>
Date: Wed, 06 Feb 2008 19:25:18 +0100
Message-ID: <a4f28$47a9fb8e$524b5c40$>

gazzag wrote:

> On 6 Feb, 11:27, "timo" <> wrote:

>> "gazzag" <> wrote in message
>> On 6 Feb, 11:03, "xxxx" <> 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.


Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Wed Feb 06 2008 - 12:25:18 CST

Original text of this message