Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: AIX file sizes
well it depends if you split the tables between disks or not....there's always a benefit to splitting a table, and putting it on a different disk, vg, and fs ...SCSI chains too if you want to get crazy
Programming wrote in message <366C3806.3A6B_at_mb.sympatico.ca>...
>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 07 1998 - 00:00:00 CST