Re: Oracle and raid

You can find an excellent article on using Oracle Financials on Sun in the OAUG Spring '97 Conference proceedings, paper 28, 'Capacity Testing of Oracle Applications on Sun Systems'. The paper is specific to one test configuration but some of the points can be generalized.

The conclusion regarding stripe size -- where full table scans are dominant, a large stripe size wins out small stripe size. Surprisingly even in OLTP applications the frequency of full table scans seems to make large stripe sizes more effective overall. However index access is quite different so if you have the option to setup more than one RAID for your system, configure the table tablespaces on the raid with large stripesizes and configure index tablespaces on the raid with small stripesizes (which improves random access performance via improving concurrent access).

I hope this helps...

>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!
Received on Thu May 14 1998 - 19:40:31 CDT