Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: determining extent size, etc.
"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 UKReceived on Tue Jun 11 2002 - 15:55:52 CDT