Re: Why "Separating Data and Indexes improves performance" is a myth?

On 04/23/2004 09:15:07 PM, Paul Drake wrote:

> 2 advil plus a dose of the paper at hotsos on
> "Aligning Oracle Blocks with Hardware Stripe
> Boundaries".

That is an extremely good article. The idea is to pick a large stripe size to minimize the number of oracle blocks being on the stripe boundary. EMC allows you to align raw devices on the block boundaries, but raw devices have headers, and you normally don't know much about those. My objection is that large stripe size sort of kills the advantage of striping in the first place. RAID-5 may be the best thing for that, as recommendend on the BARF site (www.barf.com). Mogens, can I join as member 666?

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------