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.

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

Datapump backup steps?

1 Answers  

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

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

4 Answers  

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---