Re: RAID stride size (stripe) and Oracle block size

Eugene Gardner wrote....
> > On our new RAIDs the stride size (stripe) is 64 KB. What PROVEN
> > recommendations would you have about what to set the Oracle blocksize to
> > in relation to the stride size.
> Shouldn't you get the optimum Oracle block size from the average
> amount of data which the server is asked for. Then use that to set
> your stripe (chunk) size.

You want your OBS to be a multiple of your OS block size. Pros and cons of which block size to use removed.

Now, you want your DB_FILE_MULTIBLOCK_READ_COUNT to be an even multiple of your stripe size. --- Neil

-- 
Neil Greene			Senior System Engineer / Oracle DBA	
MCI Systemhouse, Inc. 		

Email:		<mailto:ngreene_at_laoc.SHL.com>			
Pager Email:	4112636_at_PageMCI.com		Pager:	800-411-2636


-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: PGP for Personal Privacy 5.0

<encoded_portion_removed>
zeQHAKDiz0rMyO0uhvmekbN67vygKDyGLQ==
=s/sM
-----END PGP PUBLIC KEY BLOCK-----