We are moving to 92 RDBMS from an older version which did not have the
concept of locally managed tablespaces.
When should I use LOCAL vs DICTIONARY managed ? The 9i docs seem to
suggest using LOCAL for temporary tablespaces. What about permanent
ones ? One drawback I think with LOCAL is the fact that the extent
size is fixed if UNIFORM and defaulst to 1M which is small. Iwant to
use UNIFORM size to minimize fragmentation.
Which tablespace will perform better under peak loads ? We have about
500+ users querying the database at peak times. DMLs do not occur at
peak times.
Th emain table has 10 millions records and growing fast.
Any suggestions are appreciated
Thanks