Answer / swapneswar

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

Answer / mohit lalwani

SGA known as System Global Area and is a part of the Oracle instance.

SGA consist of different memory structures which are

-Shared pool (mandatory)
-Database Buffer Cache (mandatory)
-Redo Log Buffer (mandatory)
-Large Pool (optional)
-Java Pool (optional)

-SGA is sized by sga_max_size

Answer / narayan mishra

->SGA stands for System Global Area.
->it store the data and control information for oracle srever.
->it can be shared by database processes.

What is trigger and types?

0 Answers  

---

how to retrieve only duplicate values in a table

9 Answers  

---

what is a cursor

9 Answers   IBM, TCS, Wipro,

---

How can analyze query after generating explain plan ?

2 Answers   Thermotech,

---

Talk about views

10 Answers   Polaris,

---

---

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

---

How do you update a sql procedure?

0 Answers  

---

How to execute a stored procedure?

0 Answers  

---

How does one load ebcdic data? : aql loader

0 Answers  

---

how instead of triger is helpful for mutating tables errors handlling ?

2 Answers   Oracle,

---

What is sql*loader and what is it used for?

0 Answers  

---

how many no of table can be join in a sql query.

4 Answers  

---