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

Home -> Community -> Usenet -> c.d.o.server -> Re: determining extent size, etc.

Re: determining extent size, etc.

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 11 Jun 2002 21:55:52 +0100
Message-ID: <3d0663d9$0$8512$cc9e4d1f@news.dial.pipex.com>


"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D0629F4.C8EC8524_at_exesolutions.com...
>
> If it helps I generally begin the thought process using orders of
magnitude. So, for
> example:
>
> 256K
> 2.5M
> 25M
>
> Then adjust from there.
>
> Though based on some of the mythology thumping we've had around here
lately I'm not
> at all sure some people wouldn't advocate going 256K (or some other value)
for
> everything and just letting the number of extents expand indefinitely.

I think I'd start with small = stripe size (usually 64 or 128k) = multi block read count, and then as Dan says go roughly in orders of magnitude. This is almost certainly based on a complete misunderstanding of how controllers read data from disks though.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Tue Jun 11 2002 - 15:55:52 CDT

Original text of this message

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