Re: Best size for datafiles

If you use the standard Oracle8i 32-bit option on Sun Solaris, the filesize limit is 2048MB. I use data files of 2000MB.

Cheers,
Cong

"James A. Williams" wrote:

> I am on a Solaris Platform running 8.1.7. I am creating a .5 tb
> datawarehouse.
>
> I am going to have a lot of datafiles.
>
> A smaller datafile spread out generally performs better.
>
> I like 500 mb but will go with 1000 mb files.
>
> What does anyone think? Vertias options are delaylog,
> mincache=direct,convosync=direct and mincache=dsync and
> convosysnc=direct.