Answer / orawhiz

Rollback segment dynamically extent to handle larger
transactions entry loads.

A single transaction may wipeout all avaliable free space
in the Rollback Segment Tablespace. This prevents other user
using Rollback segments.

What is Server Process?

2 Answers  

---

What is hit ratio ?

13 Answers   Indiabulls, RGPV,

---

What does LGWR do?

2 Answers  

---

What Does DBWR do?

2 Answers   Honeywell,

---

How to implement the multiple control files for an existing database ?

2 Answers  

---

List the factors that can affect the accuracy of the estimations ?

1 Answers  

---

How will you force database to use particular rollback segment?

1 Answers  

---

What is function of RECO?

1 Answers  

---

What are disadvanteges of having raw devices ?

1 Answers  

---

What is meant by recursive hints ?

1 Answers  

---

How will you swap objects into a different table space for an existing database?

2 Answers  

---

What is the role of PCTFREE parameter is Storage clause ?

2 Answers  

---