Home » RDBMS Server » Performance Tuning » disk partition strategy for best performance...
disk partition strategy for best performance... [message #115165] Thu, 07 April 2005 16:40 Go to next message
Messages: 16
Registered: March 2005
Junior Member

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! Sad
Re: disk partition strategy for best performance... [message #115354 is a reply to message #115165] Sun, 10 April 2005 11:22 Go to previous messageGo to next message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member

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.

Re: disk partition strategy for best performance... [message #115408 is a reply to message #115165] Mon, 11 April 2005 07:13 Go to previous message
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.
Previous Topic: how to see the analyze table
Next Topic: Bulk Exception giving incomplete Information.
Goto Forum:

Current Time: Thu Feb 29 16:51:20 CST 2024