Re: AIX file sizes

From: MotoX <noone_at_nowhere.com>
Date: Mon, 14 Dec 1998 23:20:30 GMT
Message-ID: <36779c57.1354287@news.demon.co.uk>

I never use this option. Then again, I never use jfs much, mainly raw on AIX. Even then, I tend to split TS's up into 1Gig chunks for easier management. However Oracle 8.0.5 can have datafiles over 2G on AIX 4.3. But...

Words of warning: make sure your tools/commands work with jfs files > 2G before you go that route. Most of Oracle's tools including imp, exp, sqlloader will *not* work with files greater than 2G.

Read the AIX install guide for more details on this subject.

MotoX.

On Mon, 07 Dec 1998 14:18:14 -0600, Programming <sysdev_at_mb.sympatico.ca> wrote:

>We have just installed Oracle 8.0.5 on AIX 4.3. We have the option of
>setting the default file size to 2G or "enabling large files" which
>would give us up to 64G max per file. We do have a table which is over
>2G in size, and have always split it between two data files on the same
>disk. Would we benefit by enabling large files sizes and having the
>table created in 1 data file as opposed to 2?
Received on Mon Dec 14 1998 - 17:20:30 CST