fragmentation issues

1. using locally managed tablespaces with uniform extent sizes means that it is physically impossible to have fragmentation.
2. using dictionary managed tablespaces but create all objects with initial=next and pctincrease=0 and keep all same sized objects in a tablespace together, fragmentation is minimized

(1) is very clearcut... but my conerns are with (2) since right now, i have huge databases around 1.5GB that are on DMT. My thoughts are that it is easy to keep the initial=next and pctincrease=0. However, to keep all same sized objects in a tablespace will be tough... that will require us to have a foreknowledge of these objects beforehand... right.. but then arent we just mere human under the guidance of a almighty God.....

so my proposed solution is that since the initial=next is there... that means that all the extent sizes are the same........ and that will do the trick... isnt it?

thanks Received on Fri May 28 2004 - 21:58:14 CDT