GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Concepts and Architecture
Go To First  |  Previous Question  |  Next Question 
 Concepts and Architecture  |  Question 67 of 74    Print  
What are advantage of Data Dictionary manage Tablespace

  
Total Answers and Comments: 4 Last Update: July 15, 2009     Asked by: Ashu Shukla 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 13, 2007 00:30:36   #1  
Priyanka Arya        

RE: What are advantage of Data Dictionary manage Table...
Segments in dictionary-managed tablespaces can have a customized storage.This storage is more flexible than locally managed tablespaces but much less efficient.
 
Is this answer useful? Yes | No
April 24, 2008 13:27:59   #2  
irfanyell Member Since: April 2008   Contribution: 4    

RE: What are advantage of Data Dictionary manage Tablespace
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.
 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
December 30, 2008 10:34:23   #3  
deep chandan Member Since: December 2008   Contribution: 3    

RE: What are advantage of Data Dictionary manage Tablespace
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.
 
Is this answer useful? Yes | No
July 15, 2009 04:05:54   #4  
mmaz2002 Member Since: May 2009   Contribution: 3    

RE: What are advantage of Data Dictionary manage Tablespace
All Extent info is maintained in Dictionary which is infact a dis-advantage Also in case of a huge insert operation undo is generated.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape