What is the difference between LMT & DLT?



What is the difference between LMT & DLT?..

Answer / kittu_chintu2005

In LMT: A tablespace that manages its own extents maintains a bitmap in each datafile to keep track of the free or used status of blocks in that datafile. Each bit in the bitmap corresponds to a group of blocks. When an extent is allocated or freed for reuse, Oracle changes the bitmap values to show the new status of the blocks. These changes do not generate rollback information because they do not update tables (like sys.uet$, sys.fet$) in the data dictionary (except for special cases such as tablespace quota information).

When you create a locally managed tablespace, header bitmaps are created for each datafile. If more datafiles are added, new header bitmaps are created for each added file.

In DMT:In DMT, to keep track of the free or used status of blocks, oracle uses data dictionary tables. When an extent is allocated or freed for reuse, free space is recorded in the SYS.FET$ table, and used space in the SYS.UET$ table. Whenever space is required in one of these tablespaces, the ST (space transaction) enqueue latch must be obtained to do insert and deletes against these tables. As only one process can acquire the ST enque at a given time, this often lead to contention. These changes generate rollback information because they update tables (like sys.uet$, sys.fet$) in the data dictionary.

Is This Answer Correct ?    11 Yes 2 No

Post New Answer

More DB Administration Interview Questions

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?

0 Answers   HSBC,


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  


When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  


How do you add a data file to a tablespace?

3 Answers  


How would you extract DDL of a table without using a GUI tool?

0 Answers  






Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  


Explain an ORA-01555

2 Answers  


what is the use of recording information about current session?

0 Answers   Oracle,


What is blocking and how would you troubleshoot it?

1 Answers  


what is the difference between hot backup n rman backup?

1 Answers   Value Labs,


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  


how can you enable flashback feature?

0 Answers   Oracle,


Categories