Unanswered: Tablespace Extent and Prefetch size calculation for RAID arrays
Probably, following question may have already been discussed but i am not able to find a hit in this forum.
For a RAID array of 3+p drive and stripe size of 64K, what is a good starting point for extent and prefetch size for a tablespace defined on six logical database partitions with one cotainer on each database partition. Each database partition is on it own array group in SAN.
According to a redbook, "a good starting point would be to set extent size equal to 1 complete stripe of disks in the LUN and for the prefetch size, it must be a multiple of the extent size times the number of arrays underlying your table space.
Based on the above redbook recommendation, i came up with the
Extent sz=#disk drives in a RAID array excluding parity*RAID stripe size