Answer / swarna

SGA is a system global area (or) shared global area. The information available within this area is accessed by all users. Memory is allocated to the SGA when oracle instance starts.

Components of SGA:
1.Shared pool
(a) Library cache
(b) data dictionary cache
2.Data buffer cache
3.Redolog buffer cache
4.Large pool
5.Java pool

Size of the SGA can be view by SGA_MAX_size
The memory allocated to SGA can be viewed by Show SGA (or) show parameter sga_target.

Answer / nishi

system global area(SGA) is a shared memory regionallocated by ORACLE that contains data and control information for one ORACLE instance .

Answer / siva.k

The System Global Area (SGA) is a shared memory region
allocated by ORACLE that contains data and control
information for one ORACLE instance.

How can we plan storage for very large tables ?

1 Answers  

---

When will be a segment released?

1 Answers  

---

Diference between Oracle 9i and 10G.

2 Answers   Baidu,

---

What is the use of Oracle Control File?

0 Answers  

---

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

1 Answers   Baidu,

---

When does LGWR write to the database?

3 Answers  

---

List the Optional Flexible Architecture (OFA) of Oracle database ?

1 Answers  

---

What Does DBWR do?

2 Answers   Honeywell,

---

What is an Oracle Rollback Segment?

0 Answers  

---

What do Redo Log Buffers contain?

2 Answers  

---

What is a Rollback segment entry ?

3 Answers   TCS,

---

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

1 Answers  

---