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
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you schedule a job in database?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can you record information about current session?
What the different topologies in which replication can be configured? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
What is replication? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What the different components in replication and what is their use? : sql server DBA
what is the role of dip user in our database?
What is a correlated sub-query? : sql server DBA