Answer / Dileep Singh Rajput

The Redo log in Oracle serves two main purposes: transaction logging and media recovery. It records all changes made to data, ensuring that the database can be recovered in case of failures or errors.

How free extents are managed in Ver 6.0 and Ver 7.0 ?

1 Answers   IBM,

---

How the space utilisation takes place within rollback segments?

2 Answers  

---

what is ORACLE MEMORY STRUCTURES

3 Answers  

---

What is a Multi-threaded Server Configuration?

1 Answers  

---

Why query fails sometimes ?

1 Answers  

---

How to find the SGA Size

7 Answers   Baidu, Reliance,

---

How to find the current session sid

3 Answers   Baidu,

---

What is a Control file ?

4 Answers  

---

Name the ORACLE Background Process?

3 Answers  

---

what is the role of archiever

4 Answers   Baidu, Satyam, TCS,

---

What is an Oracle SYSTEM tablespace and when is it Created?

1 Answers  

---

What are the components of SGA?

5 Answers  

---