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 crud sql?

0 Answers  

---

Inline the values in PL/SQL, what does it mean.?

0 Answers   MCN Solutions,

---

What is trigger and types?

0 Answers  

---

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

---

What happens when a trigger is associated to a view?

0 Answers  

---

---

Why do we use partitions in sql?

0 Answers  

---

What is execution plan in sql?

0 Answers  

---

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

---

What are local and global variables and their differences?

0 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

What are the types of variable use in pl sql?

0 Answers  

---