Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 View All Answers
How to start SQL Server in minimal configuration mode?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you implement fine-grained auditing?
What authentication modes does sql server support? : sql server DBA
which background process invoke at the time of upgradation tell me???
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How do you open a cluster administrator? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what do you understand by flashback feature of oracle?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is replication? : sql server DBA
how to restore files with rman?
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the commands used in dcl? : sql server DBA
