Oracle and raid

From: <sturtle_at_my-dejanews.com>
Date: 1998/05/14
Message-ID: <6jf3es$f1r$1@nnrp1.dejanews.com>#1/1

I am implementing a financials database (~7G) using raid 0+1 on Sun Solaris 2.6. I have been puzzling over the stripe size I should use since it is critical to performance. For the test configuration, I went with the raid software default of 128K. Will be going into production soon and am considering changing the stripe size to an appropriate value. I have read that setting the stripe size too large relative to the amount of data requested will cause the controller to wait to retrieve more data than the application needs. I am using an 8K Oracle block size.

If someone can provide any insights/strategies or point me to a good paper, I would be most grateful!

Thanks for your time,

Sue Ellen Berkmeyer
DBA Sue Ellen Berkmeyer

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 14 1998 - 00:00:00 CDT