Answer Posted / munnu

PGA: Whenever a server process is started a sertain amount
of PGA memory is automatically allocated through the server
process. This memory area is a private SGA area of the
sever process and can be assed only by oracle code that
axts on behalf of that perticular server process.Two memory
area in the PGA are private SQL area and session memory.

Why is oracle so popular?

1052

---

Briefly explain what is literal? Give an example where it can be used?

1087

---

How to drop an index in oracle?

1118

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2309

---

What is the data type of dual table?

1062

---

what is IDE,DMV in sql server?

2878

---

Is truncate autocommit in oracle?

1147

---

What is meant by an index?

1218

---

What is not equal to in oracle?

1047

---

What is a named program unit?

1136

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2295

---

How to experiment a data lock in oracle?

1108

---

Is java required for oracle client?

1045

---

What is an oracle database table?

1061

---

List out the difference between commit, rollback, and savepoint?

1088

---