Hi all, Our database is currently 4GB and we are projecting it to grow to 40GB end of next year. What is the best way to allocate the tablespace/datafile config for this.

Current config is : we have 4 mount points and
1 - system
2 - Redo
3 - Data - with single datafile of maxsize 8GB
4 - Index - with single datafile of maxsize 8GB

Would it be better to add more datafiles to the existing tablepsace mount points or is it better to distribute the datafiles acorss the mount points in a round-robin fashion ?

Thanks.