From oracle-l-bounce@freelists.org  Fri Jun 17 17:41:46 2005
Return-Path: <oracle-l-bounce@freelists.org>
Received: from air891.startdedicated.com (root@localhost)
 by orafaq.com (8.12.10/8.12.10) with ESMTP id j5HMfjQv010347
 for <oracle-l@orafaq.com>; Fri, 17 Jun 2005 17:41:46 -0500
X-ClientAddr: 206.53.239.180
Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
 by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j5HMfjNi010343
 for <oracle-l@orafaq.com>; Fri, 17 Jun 2005 17:41:45 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 46DCC1BFF6A;
 Fri, 17 Jun 2005 16:38:25 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 01872-08; Fri, 17 Jun 2005 16:38:25 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BFA371BFEB1;
 Fri, 17 Jun 2005 16:38:24 -0500 (EST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=YnlMS1uMgUEPFXsLYTQT6aUWL9SAEnZJXbnGrqeJa9mpaNyOwXjIGofuuv1PKR9EtEv1YXFeezVUq7Zw890Eboi5p1bukWKm0xO9yNy77xyyplFUsZpegwgBE2g2wknzpIUJWvSa8azqwc0G4ZdYttY/fwnRuL9SdHEO0PIXHAo=
Message-ID: <bf463805061714365367c4c9@mail.gmail.com>
Date: Fri, 17 Jun 2005 22:36:38 +0100
From: Jared Still <jkstill@gmail.com>
To: ascaroth969@yahoo.co.uk
Subject: Re: Tim Gorman's "...Cost-Based Optimizer.doc"
Cc: mgogala@allegientsystems.com, breitliw@centrexcc.com,
        oracle-l@freelists.org
In-Reply-To: <20050617083246.65565.qmail@web86904.mail.ukl.yahoo.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_663_29607093.1119044198076"
References: <20050617083246.65565.qmail@web86904.mail.ukl.yahoo.com>
X-archive-position: 21334
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
X-original-sender: jkstill@gmail.com
Precedence: normal
Reply-To: jkstill@gmail.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on 
 air891.startdedicated.com
X-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE 
 autolearn=ham version=2.63
------=_Part_663_29607093.1119044198076
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 6/17/05, Stephen Barr <ascaroth969@yahoo.co.uk> wrote:
>=20
> maximum gain from pre-fetching. If the stripe size is
> too small then you may be *shattering* atomic reads
> across multiple disks and if it's too large the
>=20

This doesn't normally happen until disk rotation exceeds 50K RPM.

;)

--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

------=_Part_663_29607093.1119044198076
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 6/17/05, <b class=3D"gmail_sendername">Stephen Barr</b> &lt;<a href=3D"m=
ailto:ascaroth969@yahoo.co.uk">ascaroth969@yahoo.co.uk</a>&gt; wrote:<div><=
span class=3D"gmail_quote"></span><blockquote class=3D"gmail_quote" style=
=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; p=
adding-left: 1ex;">
maximum gain from pre-fetching. If the stripe size is<br>too small then you=
 may be *shattering* atomic reads<br>across multiple disks and if it's too =
large the<br></blockquote></div><br>
This doesn't normally happen until disk rotation exceeds 50K RPM.<br><br>
;)<br>
<br>-- <br>Jared Still<br>Certifiable Oracle DBA and Part Time Perl Evangel=
ist<br><br>

------=_Part_663_29607093.1119044198076--
--
http://www.freelists.org/webpage/oracle-l