Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What are the ways tablespaces can be managed and how do they
differ?

Answers were Sorted based on User's Feedback



What are the ways tablespaces can be managed and how do they differ?..

Answer / ram

tablespaces can be managed in 2 ways 1) Dictionary Managed
2) Locally managed

in DMT data dictionary tables stores the information of free and used extents, for used extents information in dmt tablespace uses sys.uet$ view and free extents information in DMT tablespace stored in sys.fet$

in LMT tablespace, tablespace datafiles maintains own bitmaps @ datafile headers these store the used extents and free extents information.

LMT is preferable, because it won't generate any rollbacks,
dictionary contention is reduced, space wastage removed & fragmentation removed

Is This Answer Correct ?    2 Yes 0 No

What are the ways tablespaces can be managed and how do they differ?..

Answer / kittu

tablespaces can be managed in 2 ways 1) Dictionary Managed
2) Locally managed

In dictionary managed tablespace oracle will take care of tablespace

In locally managed tablespace we need to take care of tablespace

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More DB Administration Interview Questions

wat is global index and local indes

1 Answers   Oracle,


You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  


now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,


What is transparent data encryption? : sql server DBA

0 Answers  


How many memory layers are in the shared pool?

3 Answers  


Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  


In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,


Explain an ORA-01555

2 Answers  


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  


What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  


What view would you use to determine free space in a tablespace?

3 Answers  


what is incremental checkpoint?

1 Answers   CTS,


Categories