Hi recently, i was tasked to upgrade our current Oracle 9i DB Server. I intend to configure the new server with the following specs,
1) Running Win2003 Ent Server (32bit) & Oracle 9i DB Server
2) Dual Processor
3) 4GB RAM (or maybe more)
4) Having 3 Raid Controller Cards with 3 Raid settings,
i) Raid 1 -> For OS
ii) Raid 1 -> For Log Files
iii) Raid 0+1 (6 harddisks) -> For Oracle Datafiles
Does this help to enhance performance if i separate the log files & OS to different raid controller card?
Basically, this is what i plan to create for the new serve. Appreciate any advise whether this is workable or there is any modification that i need to make. THanks!
This certainly sounds reasonable. Depending on the size of your logs and the physical disks you're getting, I'd consider having a mirrored pair for the OS and put 8 drives in the 0+1 and put the logfiles on it. I'd guess you're getting at least 72G drives. For a 210G or smaller db (3x72) I'd be surprised if you're using more than about 10G for online logfiles. Now you're wasting 62G of space. I'd rather use the extra physical spindles on my 0+1 for overall throughput and utilization of space. But that's just my .02, and the way you have it is fine.