Re: Oracle Locally Managed Tablespaces

This might answer some of your question:

http://www.dizwell.com/oracle/articles/fragmentation.html

And this might answer the rest:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:5549302357655

So you might want to make the initial the same size that autoallocate will make the rest. But if you do nothing, LMT will generally do the right thing.

My experience has been autoallocate works well, even with initial's that have been messed up by compress=y several versions ago.

jg

--
@home.com is bogus.
Think outside the bun:
http://www.signonsandiego.com/uniontrib/20051021/news_1b21taco.html