What are the ways tablespaces can be managed and how do they
differ?
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 process messages in order asynchronously?
What are the commands used in dcl? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
What is transparent data encryption? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Where would you look for errors from the database engine?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What the different types of replication and why are they used? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is logical system in sap basis
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how can you record information about current session?