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
- 6623 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
What is the default port no on which sql server listens? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is dcl? : sql server DBA
what is a crs resource?
how can you record information about current session?
What are the commands you'd issue to show the explain plan for "select * from dual"?
How can you control the amount of free space in your index pages? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is a correlated sub-query? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
What is the difference between clustered and non-clustered index? : sql server DBA
what is grd?
what is logical system in sap basis
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
