What is the advantage of using locally managed tablespaces?

  • Interview Candidate
  • 7
  • 1829

Showing Answers 1 - 7 of 7 Answers

innovative

  • Feb 20th, 2006
 

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.....

  Was this answer useful?  Yes

Mohammed Abdul Afroze

  • Nov 1st, 2007
 

  • 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).
  • Reduced fragmentation .

  Was this answer useful?  Yes

ghos.rahul

  • Dec 29th, 2008
 


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.

Hope this serves the purpose.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions