Re: RAID 0+1 and recommended stripe size

Thanks Connor, for the confirmation, and to Joel as well for the SAME article.
I will definitely try the suggestions I've received and benchmark for our system.

btw, I notice in that SAME article that Joel has provided:

http://otn.oracle.com/deploy/availability/pdf/oow2000_same.pdf

that Juan Loaiza et al. suggests using 1 meg stripes, as well as a 1 meg db_file_multiblock_read_count, and OS IO size limits to 1 meg.

I'm wondering if anyone has tried both methods and has an informed opinion on which is _generally_ more performant? Mind you, I'm not after some magical incantation like fast=true, just a push in the right direction to start off my testing/benchmarking.

My reasoning: I'm pressed for time on this issue so the option to try every possible way is out of the question.

Thanks again everyone for the suggestions!

Cheers,

Bricklen

Connor McDonald wrote:
> The general consensus around the place is:
>
> block size * multiblock read * n
>
> where n = 1, 2, 3, ... etc
>
> Which 'n' is best? For *your* system it could be any of them, if you
> can run some benchmarks you'll find the best for your system. It might
> match the thoughts out there in the public forums, it might not...But
> you will at least know thats its the best for *your* system
>
> hth
> connor
> --
> =========================
> Connor McDonald
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue"
Received on Thu Mar 20 2003 - 09:44:45 CST