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 the difference between having and a where in sql?

0 Answers  

---

Does oracle roll back the transaction on an error?

0 Answers  

---

What are types of joins?

0 Answers  

---

What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,

---

Explian rowid, rownum? What are the psoducolumns we have?

0 Answers  

---

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---

what is meant by DML?

5 Answers   HCL,

---

What is audit logout in sql profiler?

0 Answers  

---

How to display the contents of a current record fetched in a reference cursor?

2 Answers  

---

What is a clob in sql?

0 Answers  

---

What is a variable in sql?

0 Answers  

---

Why having clause is used in sql?

0 Answers  

---