RE: Any good papers on raid 10 setup for oracle?

There is stripe depth AND stripe width.

You guys need to make sure you are talking about the same things. I have found in the past that communication on this subject can be difficult between DBAs and storage admins.

You'll need to familiarize yourself as much as possible with storage techniques PARTICULAR to your PARTICULAR SAN (HP, EMC, IBM, whatever).

You may want to get a storage tech on the phone from your vendor (an actual techie) and have your storage admin with you to discuss questions. INVALUABLE in my opinion to do this together with a vendor tech who does customer setups.

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor_at_ingrambarge.com  

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Schmitt Sent: Friday, September 25, 2009 9:27 AM To: oracle-l
Subject: Any good papers on raid 10 setup for oracle?

Hi All,

Can anyone point me to some good info on best practices for raid 10 for oracle (mainly stripes sizing)?

Background:
We are going to be testing some raid 10 and our SAN Admin set the stripe size to 512 bytes. From what I have read in the past, I was thinking Oracle would do better off closer to a stripe size of <db_block_size>*multibock_read_count, however it has been awhile since I looked into it. I know it always depends, but the 512 bytes doesn't sound correct to me

Thanks

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 25 2009 - 10:36:22 CDT