Dear friends,
I need a help from u all. Right now i planning to use dictionary managed tablespaces, but so many documents says that LMT(locally managed tablespaces) is very good in performance and also in maintenance. I am convinced with that. I didn't understand one thing during my testing, I have create an LMT with 1m of uniform extent allocation, and at the table level i gave 5m as initial extent, when i queried dba_extents, it has taken 5 extents of 1m each, is this right even in case of initial extent also? will it not take the initial extent which is given at the table level?

One more doubt, in earlier versions documents says that too many extents is performance drain, is it same in 8i also?
Till how many extents i can plan for a table and how many are suggestable?
See i have tables of size 60gb and 30 gb which will grow in a year, how can size this. please help me in this regard..

Thanks in Advance.