Interested to Buy Any Domain ? << Click Here >> for more details...
What are the ways tablespaces can be managed and how do they
differ?
- 2 Answers
- 6656 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how can you connect from 10g user to 11g user??
what is grd?
what is logical system in sap basis
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the commands used in dcl? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the different ways you can create databases in sql server? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are the different sql server versions you have worked on? : sql server DBA
what is a user-defined lock?
What are the steps you will take to improve performance of a poor performing query?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how can you initialize log miner?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
