Re: Algorithm for calculating extent size in LMT

Comments Embedded

Regards,
Ganesh R

"EP" <ep_at_plusnet.pl> wrote in message news:<a60ff8$isp$1_at_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 !!!

Are You Sure... I Feel you are talking about Dict Managed TBS and that is almost History now considering 9i is pushing for LMT's in a Big way.

LMTS Dont use the Initial Next and MinExtents they are ignored when a TBS is declared as a LMT.

> 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).

Absolutley Wrong ... See above !!!

>
> Regards,
> EP
Received on Tue Mar 05 2002 - 02:09:08 CST