Re: Why "Separating Data and Indexes improves performance" is a myth?
- From: Mladen Gogala <mgogala@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 23 Apr 2004 21:35:04 -0400
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
