Answer Posted / 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

How to call shell script from pl sql procedure?

1280

---

When is the explicit cursor used ?

1035

---

What is row_number () in sql?

983

---

what is the use of set statement in tsql? : Transact sql

1011

---

What is sorting in sql?

948

---

How long will it take to learn pl sql?

936

---

What is a column in a table?

1126

---

What sql database should I use?

1145

---

In pl/sql, what is bulk binding, and when/how would it help performance?

994

---

Define overloaded procedure?

1081

---

what is sql in mysql? : Sql dba

1196

---

what is the difference between group by and order by in sql? : Sql dba

1128

---

Who is the owner of mysql database?

1057

---

What are the limitations of sql express?

1071

---

How to take user input in pl sql?

1163

---