Re: Formula for Calculating Maxextents

Hi,

The reason why I use that complex formula is the formula was derived from the origin.

 M = ( ( b- sizeof (kcbh))/2 - sizeof (ktect) )/sizeof (ktetb)

 where b is the value of db_block_size, and sizeof( ) can be found by querying the
 v$type_size dynamic performance table:  select component, type, "SIZE" from v$type_size ;

The column name size is a reserved word so the workaround when do the select statement, you have to do as above.

John Durst wrote:

> 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 Thu Oct 22 1998 - 13:38:26 CDT