Re: Tablespace/Datafile Layout for Datawarehouse

"Greg Rahn" <greg_at_structureddata.org> wrote in message news:1181361923.331612.140660_at_r19g2000prf.googlegroups.com...
> Why do you limit the data files to only 4GB? If you are using an 8k
> block you can go up to 32GB. This would reduce the amount of open
> file handles.
>
> If the disks are 98+% busy, it's time to add some more spindles.
>
> --
> Regards,
>
> Greg Rahn
> http://structureddata.org
>

Would I be correct in making the following two assumptions?

1. If using a 16K block size then the data files could go up to 64GB.
2. Fewer but larger data files are preferable over more but smaller data files.