RE: What is the advantage of using locally managed tab...
data dict. contention is less prone to contention coz when there is dict. managed tablespaces the info about them is stored in dictionary and to manage it manually is very confusing so it is better to use automatic management. as in 8i rollback segments were used u can ask any dba working on oracle 8i he will agree for automatic.....
RE: What is the advantage of using locally managed tab...
Advantages in using Locally Managed Tablespaces:Because locally managed tablespaces do not record free space in data dictionary it reduces contention on these tables.
Local management of extents automatically tracks adjacent free space eliminating the need to coalesce free extents.
Avoids recursive space management operations which can occur in dictionary-managed tablespaces if consuming or releasing space in an extent results in another operation that consumes or releases space in a rollback segment or data dictionary table.
Sizes of extents that are managed locally can be determined automatically by the system. Alternatively all extents can have the same size in a locally managed tablespace.
Changes to the extent bitmaps do not generate rollback information because they do not update tables in the data dictionary (except for special cases such as tablespace quota information).
RE: What is the advantage of using locally managed tablespaces?
In adddition to the answers given earlier.
In a technology like Orcale one should always remember there is nothing absolute everything is optimum.There is nothing actual advantage of using Locally Managed Tablespace over System Managed Tablespace. The diference lies with the scenarion. What ever the differences have been posted in reply to this thread holds good if one is managing Tablespace which contain user data. But as for the tablespace like SYSTEM UNDO TEMP it is not only advisible but also highly recomended that we use dictionary managed options.
