disk partition strategy for best performance... [message #115165] |
Thu, 07 April 2005 16:40 |
760613
Messages: 16 Registered: March 2005
|
Junior Member |
|
|
Hi,
Im about installing Oracle10g on a Windows 2003 Server and appreciate any help you can afford me.
The Server is provided with a RAID controller and two 146GB SCSI disks, which are in RAID 1 (mirrored).
Im indecisive about the disks and partitions.
Do you have any advices?guides? to partition the disks for best performance.
Thank you!
Ive asked this question in the 'platforms' ( http://www.orafaq.com/forum/t/42776/68126/ ) category but didnt get any answers in weeks!
|
|
|
Re: disk partition strategy for best performance... [message #115354 is a reply to message #115165] |
Sun, 10 April 2005 11:22 |
Frank Naude
Messages: 4587 Registered: April 1998
|
Senior Member |
|
|
Hi,
If you have 2 disks that is mirrored, you end up with one usable disk. How you partition it would not make a big difference. If you want to improve I/O performance, consider adding more disks. Many smaller disks are usually better than a few larger ones.
Best regards.
Frank
|
|
|
Re: disk partition strategy for best performance... [message #115408 is a reply to message #115165] |
Mon, 11 April 2005 07:13 |
smartin
Messages: 1803 Registered: March 2005 Location: Jacksonville, Florida
|
Senior Member |
|
|
I'd agree with Frank. Also, you may want to look for a document on the oracle (or otn.oracle) website referring to something called S.A.M.E. Stripe And Mirror Everything.
But basically if you only have two disks total in mirror, and don't have or won't get any others, then it won't matter at all what you do.
|
|
|