Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: AIX file sizes

Re: AIX file sizes

From: Jim <c0leslawz_at_yahoo.com>
Date: 1998/12/07
Message-ID: <74hg5n$i19$1@usenet49.supernews.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US