Instead of a LMT with UNIFORM extent sizes, consider using AUTOALLOCATE.
Your extent sizes will not all be the same size, but that is no problem.
And you won't have the fragmented free space problem you are running
into with DMT's. If Oracle is attempting to allocate a 1MB extent and
there are only smaller free extents available, Oracle will automatically
break this up and use that smaller space.
HTH,
Brian
--
===================================================================
Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net
Remove the "nospam." from the email address to email me.
"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Thu May 25 2006 - 15:11:46 CDT
