Say that I have 6 disks. All of the disk arrays are RAID 10. What would be the best optimial separate of tablespaces. Example:
Disk array 1: TEMP
Disk array 2: Data
Disk array 3: Indexes
Disk array 4: RBS
Disk array 5: Archive logs
Disk array 6: Oracle Home and Ctl with System Tablespace
What u have choosen is right...make sure that u dont place data and index tablespace in the same disk..Also make sure u set ur archive destination to a seperate disk....
Also Multiplex/ copies ur redologs & control files in different disks.
Archive destination to a seperate disk.
Depends, what's your I/O distribution? On a system with only 6 disks, does SYSTEM, RBS and Archive logs warrent a dedicated device?
I would look at my I/O patterns. If you have really hot data files, I would spread them out on multiple devices. If you are archiving once every 2 hours, I would put other data files on that device as well. With 6 disks, you want all of them to carry approximately 16% of the I/O burden.