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 |
which background process will run @ the time of creation of catalog database
What is the default fill factor value? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what are the types of connection load-balancing?
why do we give pctfree and pctused in create table statement?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
WHEN DOWN TIME WHAT CAN U DO?
Which autogrowth database setting is good? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
why we use cursors