Re: Formula for Calculating Maxextents

Hello all out there,

Note that this formula also holds for block sizes not a power of 2 in K's, for example:

 block size max extents

 3 K 185

There seem to be exotic OS's where the OS block size is 3K, you would like to have 3K or 6K oracle blocks (6 -> 377) to get good OS block fill-up on such systems,

greetings,

Harm ten Napel

Tommy wrote in message <362D3596.6ACEA479_at_yahoo.com>...
>Hi,
>
>On typical unix system the maxextents formula reduces to :
>
>
> M = ((b-24)/2 - 44)/8
>
>where b is db_block_size
>
>See the Table below
>
> db_block_size Max Number of extents per Segment
> 2,048 121
> 4,096 249
> 8,192 505
> 16,384 1,017
> 32,768 2,041
>
>
>The maximum number of extents that an Oracle Server version 7.0, 7.1, or
>7.2
>segment can contain is a function of the value of db_block_size for the
>database on a given operating system. The figures shown here are for a
>typical UNIX implementation of Oracle Server. Version 7.3 is scheduled
>to remove the limit on the number of extents per segment.
>
Received on Wed Oct 21 1998 - 15:47:35 CDT