You don't HAVE to change back to DMT to solve this problem.
you could :
1. create 2 or 3 tablespaces with a different uniform extent size and house each object into the appropriately sized tablespace.
2.Create a LMT with Automatic Extent Allocation instead of Uniform Extent Size. Oracle will deal with assigning appropriately sized extents for these objects and will allocate larger extents to the objects as they grow.
The sizes it allocates are initialy 64k, until the object reaches 1mb in size, the extent will then change to 1Mb, when the object reaches 64mb then extent = 8mb, until it reaches 1Gb then extent = 64Mb.
A lot of people don't actually use the Automatic Extent Allocation because I guess it has something to do with space being wasted.
Can anyone explain any disadvantages to using Automatic Extent Allocation ?
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
Reply With Quote