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 the significance of having storage clause ?

1 Answers  

---

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

0 Answers  

---

how oracle will recognise its space is 100gb if 100gb is allocated for it...

1 Answers   Baidu,

---

What is SGA?

3 Answers  

---

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

0 Answers  

---

How to find the SGA Size

7 Answers   Baidu, Reliance,

---

What is meant by free extent ?

2 Answers  

---

What Does DBWR do?

2 Answers   Honeywell,

---

What does LGWR do?

2 Answers  

---

what is ORACLE MEMORY STRUCTURES

3 Answers  

---

How will you monitor rollback segment status ?

2 Answers  

---

What are the consideration at tehe migration of Oracle 9i to 10G.

0 Answers   Baidu,

---