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.

Which command is used to delete a package?

0 Answers  

---

What is nvl?

0 Answers  

---

What is the difference between an inner and outer join?

0 Answers  

---

What are transaction and its controls?

0 Answers  

---

Determine if oracle date is on a weekend?

0 Answers  

---

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  

---

explain normalization concept? : Sql dba

0 Answers  

---

How insert into statements in sql?

0 Answers  

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

Explain autonomous transaction.

0 Answers  

---

How can you create Cursor with parametres ?

3 Answers  

---