Re: Warehouse Stripe Size with Oracle8

From: Jerome Peter <jerrym_at_cix.compulink.co.uk>
Date: Wed, 17 Feb 1999 17:57:04 GMT
Message-ID: <F7B8J4.1B0@cix.compulink.co.uk>

Howard Galusha said .....
>Our system DBA's set up the Oracle blocksize to be 32K
>The disk arrays were set up with a 512 byte stripe size.
>
>Now, intuitively, the stripe size sounds way too small -
>I picture the o/s getting swamped performing 64 i/o's to
>read 1 Oracle block
>

I'm sorry that I don't know much about VMS, but the recommendation we've adopted on our Data Warehouse (which was made by the hardware manufacturer) running on Unix is to set the strip size to be the same as the largest physical I/O the Operating System is capable of doing (in our case this is 64KB). This means that your table scans (using multiblock_read_count) will retrieve as much data as possible in a single I/O.

As an aside, where did you find a copy of the book "Oracle Consulting's Physical Database Design Guide by Rainer Runge" which you mentioned ?

I hope some of this helps ..... Jerry Received on Wed Feb 17 1999 - 11:57:04 CST