Re: base 2 or base 10?
- From: Dennis Williams <oracledba.williams@xxxxxxxxx>
- To: DMcGibbon@xxxxxxxxxxxx
- Date: Wed, 28 Sep 2005 17:11:38 -0500
Dougie,
You are most likely correct. Long day, long time since I did this
particular exercise.
Dave,
Create your table with extent size of 1M or 20M and then check to see
what size Oracle actually used to create it. My guess is that for
those sizes, it will be exactly what you asked for. If you'd used
10000 then it would round since that isn't "binary" according to your
definition. Anyway the point is to check to see what Oracle actually
did rather than assume. :-)
Dennis
On 9/28/05, Dougie McGibbon <DMcGibbon@xxxxxxxxxxxx> wrote:
>
>
> > Oracle will round the extent size up to an even block size. So you
> > should use binary for extent sizes.
>
> I always thought Oracle rounded up to the nearest factor of five blocks -
> ask for 7 blocks and you got 10 ???
>
>
> Dougie McGibbon
--
//www.freelists.org/webpage/oracle-l
Other related posts:
