Concepts and Architecture - What are advantage of Data Dictionary manage Tablespace

GeekInterview.com > Interview Questions > Oracle > Concepts and Architecture

Go To First | Previous Question | Next Question

Concepts and Architecture | Question 67 of 74

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

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

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

0 1

Overall Rating: -1

December 30, 2008 10:34:23

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

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

User Name		Remember Me?
Password

Question Bank