Since you have 5 disks only, my suggestion is use RAID 0 - Striping alone. Simple striping across 5 disks at about 64K or 128K per disk (stripe unit size) is probably the best way of minimizing I/O contention.
Create fewer mount points. Other wise, later you will find that one mount point will be more heavily used than others.
Originally posted by rshivagami 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 ?
Your current config looks just fine. But in the end its the actual I/O that needs to be monitor. If you see improper I/O distribution then might need to move data files from 1 disk to the other or your subsequent addition of data files will be considered. And assuming that your mount points are for each disk. But this is only effective when no RAIDs implementation, do you have one?