Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 64k or 128k stripe - 8k block 8 multiblock read?
Noons wrote:
>"Domenic G." <domenicg_at_hotmail.com> wrote in message news:c7e08a19.0309181631.14ab09a4_at_posting.google.com...
>
>
>>Quick question ...
>>
>>Assuming a db_block_size of 8k with a db_file_multiblock_read_count of
>>8
>>
>>8k x 8 = 64k
>>
>>Should I set my disk stripe size to 64k or 128k for the most efficient
>>I/O for FTS? The Oracle docs give contradictory advice.
>>
>>
>
>
>I'd say 64K, but 128 shouldn't make that much difference. Provided
>of course your tables ARE larger than 128K! :D
>
>If you're running Windoze, you could go up to 512K, IIRC. There was
>a thread a while ago about this. Some Unix version will stop at
>512, others will let you go 1Mb. I think HP/UX.
>
>www.ixora.com.au has some stuff on this.
>
>
>
And AIX.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri Sep 19 2003 - 09:20:27 CDT