Formula for Calculating Maxextents

From: Tommy <tcusan_at_yahoo.com>
Date: Tue, 20 Oct 1998 17:15:02 -0700
Message-ID: <362D3596.6ACEA479@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 Tue Oct 20 1998 - 19:15:02 CDT