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
- 6764 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
Where do you find the default index fill factor and how to change it? : sql server DBA
what is a user-defined lock?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What the different topologies in which replication can be configured? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What is a correlated sub-query? : sql server DBA
What purpose does the model database server? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
What is transparent data encryption? : sql server DBA
what is grd?
how to restore files with rman?
what is ora 24313?what is the procedure to exclude that error?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
