Re: Algorithm for calculating extent size in LMT

From: EP <ep_at_plusnet.pl>
Date: Mon, 4 Mar 2002 19:48:45 +0100
Message-ID: <a60ff8$isp$1@news.tpi.pl>

> There is no such thing. Extent sizes are determined by developers and DBAs
> that do their homework and determine the idea size for a class of tables.
> Often ... creating multiple tablespaces with different extent sizes to
avoid
> both fragmentation and keep the number of segments ?small.

You are mistaken here, as with the autoallocate option you also have to calculate such parameters as INITIAL, NEXT and MINEXTENTS, so DBA homework is done as well !!!
As far as the number of extens goes, Oracle's calculation is based on the above parameters, so you don't need to worry about too many extents (unless you have made a mistake while estimating these parameters).

Regards,
EP Received on Mon Mar 04 2002 - 12:48:45 CST