Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Algorithm for calculating extent size in LMT
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.
Daniel Morgan
EP wrote:
> Hi
>
> Does anybody know the algorithm used by Oracle when calculating the extent
> size for LMT when autoallocate option is specified ???
>
> TIA
> EP
Received on Sun Mar 03 2002 - 16:12:33 CST