Re: Oracle on a VA7400 from HP

"John van Eck" <JvanEck_at_ssc.dordrecht.nl> writes:
>
>The HP consultant however did not know much about Oracle, so with setting
>the logical volume stripe size (lvcreate) he could not give any advice on
>how the set the stripe size.
>We got OS and database block sizes of 8Kb, so the stripe size should be 8Kb
>or a multiple of 8Kb. So far so good. But because you have no control of

What do you mean by stripe size? Are you creating multiple LUNs and then combining them into a single volume group and striping across? Why? The whole idea of the array is that you request a chunk of disk space and the array gives it to you. You cannot control placement of data on the array -- the array may switch between RAID levels and even migrate data between disks as disks are added, LUNs are created or disks are removed or hotspared. Only create as many LUNs as you would have created volume groups (for logical separation of data, not for performance).

You have to forget the traditional practise of DBAs controlling placement of data by optimizing disks, logical volumes, stripe sizes etc. In any case, the array has about half a Gig of cache, so unless your data flow is really really huge, you'll be reading/writing to memory most of the time. Things have changed, long live the new flesh.

-- 
Vartan