Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tim Gorman's "...Cost-Based Optimizer.doc"

Re: Tim Gorman's "...Cost-Based Optimizer.doc"

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 17 Jun 2005 22:36:38 +0100
Message-ID: <bf463805061714365367c4c9@mail.gmail.com>


On 6/17/05, Stephen Barr <ascaroth969_at_yahoo.co.uk> wrote:
>
> 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
>

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

;)

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

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 17 2005 - 17:41:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US