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
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! 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: 4579
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 Go to previous message
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.
Previous Topic: how to see the analyze table
Next Topic: Bulk Exception giving incomplete Information.
Goto Forum:
  


Current Time: Thu Mar 28 18:08:32 CDT 2024