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 do you trace the traffic hitting a sql server? : sql server DBA
what is logical system in sap basis
What happens on checkpoint? : sql server DBA
how to restore files with rman?
What are the operating modes in which database mirroring runs? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how can you implement fine-grained auditing?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
