Priyanka Arya

• Nov 13th, 2007

 

Segments in dictionary-managed tablespaces can have a customized storage.This storage is more flexible than locally managed tablespaces but much less efficient.

irfanyell

 Profile Answers by irfanyell 

• Apr 24th, 2008

 

In dictionary managed tablespace the user can know aboout what is happening with tablespace because in this tablespace the extent management is manual. and user need to give the extent sizes.

deep chandan

 Profile Answers by deep chandan 

• Dec 30th, 2008

 

The main advantage of using dictionary managed tablespaces is that in this we can give the size of the extents according to our need. We can modify extent size but in locally managed tablespace extents are of uniform size.

mmaz2002

 Profile Answers by mmaz2002 

• Jul 15th, 2009

 

All Extent info is maintained in Dictionary which is infact a dis-advantage, Also in case of a huge insert operation undo is generated.