Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: LMT advice
Daniel Morgan wrote:
> foolishHurts wrote: >
> Use UNIFORM ... it eliminates tablespace fragmentation. > > Archive can be viewed through google.com. >
So does using autoallocate, since even if it gives you a 1 MB extent, it's handled by actually allocating you multiple 64K 'subextents'.
There is no reason I can think of not to use autoallocate.
Note to the original poster: since autoallocate only ever allocateds 64K, 1M, 8M and 64M (and 256M) extents, I'm not entirely sure how you managed to get 100K extents. Also, the algorithm really will start scaling up the extents' size to prevent the allocation of thousands of small extents. So whatever it is you've done, it isn't autoallocate!
Regards
HJR
Received on Thu Sep 25 2003 - 15:29:54 CDT