Re: Formula for Calculating Maxextents

Funny, I thought the formula was M=(b/16)-7!

Tommy wrote:

> 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 - 18:43:14 CDT